Oracle Create Index

Oracle database indexes are very important for SQL performance tuning and they are crucial for SQL query optimization. SQL Performance Tuning recommend that you create Oracle index or indexes on some table fields which are used in where clause. We recommends also to do some tests, before you do code to production environment.

EXAMPLE:

SQL query (note field priority in WHERE clause):

Create index:

For SQL query performance optimization we recommends to create oracle index on field priority.