Index [message #360912] |
Mon, 24 November 2008 06:08 |
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 |
Frank Naude
Messages: 4580 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
|
|
|
|