Home » SQL & PL/SQL » SQL & PL/SQL » sql - index (oracle9i)
sql - index [message #277525] Tue, 30 October 2007 07:52 Go to next message
jigart4586
Messages: 3
Registered: October 2007
Location: india
Junior Member

create index isal on
emp(sal);

Iknow how to create index,
but i don't know what is use of it.
how to use this index in other query.
give one example.

Please help me.

Thanks in advance.
Re: sql - index [message #277526 is a reply to message #277525] Tue, 30 October 2007 07:57 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:

how to use this index in other query.
give one example.

select * 
from emp
where sal = 24000;

May use the index (but then again it might not.
Have you read the extensive documentation on indexes available from
http://tahiti.oracle.com
Re: sql - index [message #277527 is a reply to message #277525] Tue, 30 October 2007 08:00 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
What do you use an index for in a book (like the Oracle documentation)? It's the same concept.
Re: sql - index [message #277529 is a reply to message #277525] Tue, 30 October 2007 08:03 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 5 Schema Objects
Section Overview of Indexes

Regards
Michel
Previous Topic: query
Next Topic: Generate trigger statement using store procedure
Goto Forum:
  


Current Time: Fri Dec 02 12:43:28 CST 2016

Total time taken to generate the page: 0.12491 seconds