Home » SQL & PL/SQL » SQL & PL/SQL » Definite Indexing scenarios (Oracle 10g)
Definite Indexing scenarios [message #294303] Thu, 17 January 2008 02:58 Go to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
Could you please list definite situations/instances where we should surely create an index ?
Re: Definite Indexing scenarios [message #294304 is a reply to message #294303] Thu, 17 January 2008 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Performance Tuning Guide
Chapter 2 Designing and Developing for Performance
Section 2.5 Application Design Principles
Subsection 2.5.3 Table and Index Design

Chapter 15 Using Indexes and Clusters

Regards
Michel
Re: Definite Indexing scenarios [message #294305 is a reply to message #294303] Thu, 17 January 2008 03:06 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
An index should definitely be created in situations where it is needed.
Re: Definite Indexing scenarios [message #294310 is a reply to message #294305] Thu, 17 January 2008 03:26 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
ThomasG wrote on Thu, 17 January 2008 09:06
An index should definitely be created in situations where it is needed.

And one shouldn't create an index when it will never be used.
Re: Definite Indexing scenarios [message #294311 is a reply to message #294303] Thu, 17 January 2008 03:28 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member


Quote:
Could you please list definite situations/instances where we should surely create an index ?


Quote:
An index should definitely be created in situations where it is needed.


interesting Smile

Thumbs Up
Rajuvan.
Previous Topic: Oracle date comparison issue
Next Topic: Grant User
Goto Forum:
  


Current Time: Tue Feb 11 13:44:02 CST 2025