OraFAQ Forum: Performance Tuning » is unique index helpful in making query fast?

Home » RDBMS Server » Performance Tuning » is unique index helpful in making query fast?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

is unique index helpful in making query fast? [message #177308]

Wed, 14 June 2006 01:51

a_developer
Messages: 194
Registered: January 2006

Senior Member

I have a unique index on 2 columns, example last_name and first_name. Most of the time, I search for records with these 2 columns in my where clause. Do I need to create a separate b-tree index to quicken the query or is the UNIQUE index enough???

Report message to a moderator

Re: is unique index helpful in making query fast? [message #177315 is a reply to message #177308]

Wed, 14 June 2006 02:35

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

The index that you currently have should sufice. However, if you are not convinced, why not do a test?

Report message to a moderator

Previous Topic:	database slow
Next Topic:	queries on collecting schema statistics (oracle 9i)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 03:07:46 CDT 2024