Home » RDBMS Server » Performance Tuning » Index (Oracle 10g)
Index [message #360912] Mon, 24 November 2008 06:08 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Normally how we can decide that there is need to create an INDEX of COMPOSITE INDEX on the table?

Any specfic criterias if any?
Thanks,

Re: Index [message #360920 is a reply to message #360912] Mon, 24 November 2008 06:22 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
This is a complicated question. Generally speaking, columns that are ALWAYS used together as a key should get composite indexes. The rest should have single column indexes.

I would suggest that you ask a professional designer for some assistance. It is also a good idea to test different configurations to see which would work best for your application.

Regards.

Frank
Re: Index [message #360921 is a reply to message #360912] Mon, 24 November 2008 06:23 Go to previous message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Frank,
Previous Topic: Table size and sql performance
Next Topic: High I/O disk writes
Goto Forum:
  


Current Time: Sat Dec 10 01:17:44 CST 2016

Total time taken to generate the page: 0.26023 seconds