How to create the index..??
-
I have the next query:
-
select * from t1
where c1=1234 and c2='abc' and c3=789 and c4='fgh';
-
What is the best way to create the index for the previous query.?
a) create index idx1 on t1 (c1,c2,c3,c4);
b) create index idx1 on t1 (c4,c3,c2,c1);
c) other
Does anybody have a link or a document where I can learn to structure the "WHERE" clause in a query?
-
Thanks in advance.