Oracle DBA Forums > use index

Full Version: use index

rupaparamahesh

Jul 14 2008, 03:48 AM

index is use for increase performance write. so ,
how can use index in select query for increase performance?
wait for reply thanks.

Florin Aparaschivei

Jul 14 2008, 06:33 AM

aussie_dba

Jul 14 2008, 11:24 AM

"how can use index in select query for increase performance?"

After you create an index, the SQL will automatically find the index and use it:

http://www.dba-oracle.com/concepts/creating_indexes.htm

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.