simple question about oracle indexes
Posted
by john
on Stack Overflow
See other posts from Stack Overflow
or by john
Published on 2010-06-03T05:18:53Z
Indexed on
2010/06/03
5:24 UTC
Read the original article
Hit count: 131
If I have an oracle query like below:
SELECT * FROM table_a where A = "1", B = "2", C = "3"
for this query to pickup one of the indexes of table_a...does the index need to be on all 3 of these columns?
What I am asking is:
What if Index is on A, B, C, D?
What if Index is on B, C?
Will the index only be picked when it is on A, B, C?
© Stack Overflow or respective owner
