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: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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: 3189
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: 2835
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: Fri Dec 09 06:08:45 CST 2016

Total time taken to generate the page: 0.08096 seconds