Database Tuning (MOSC)

MOSC Banner

How to create the index..??

edited Dec 24, 2009 5:43PM in Database Tuning (MOSC) 3 commentsAnswered
Hi

-

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center