| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
