sql query and index
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi all, I am using query something like that select * from table1 where column1 = 'value1' and column2 = 'value2'; and I have created the index like this create index index1 on table1( column2 ); i have used only one column because column2 is usually unique and can only sometimes repeat Will the query will use the index or do i have to create index with both columns? I am using Oracle database.
Regards Shajeel