Home » RDBMS Server » Server Administration » indexes
indexes [message #57858] Fri, 11 July 2003 07:08 Go to next message
Sunitha
Messages: 16
Registered: January 2000
Junior Member
what is exact use or advantage of indexes when it will be used frequently pls clarify

Report message to a moderator

Re: indexes [message #57872 is a reply to message #57858] Mon, 14 July 2003 02:24 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Indexes I
Indexes II
Indexes III

The advantage of indexes is: PERFORMANCE. It can seriously lower the response times of an application. There are several types of indexes but if you search the Oracle online documentation (at tahiti.oracle.com) you'll find tons of information.

MHE

Report message to a moderator

Previous Topic: is there any EXISTS() in oracle
Next Topic: identification of long running SQL queries
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 22 12:08:08 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.