| SELECT STATEMENT [message #374556] |
Mon, 18 June 2001 12:40  |
Odell Walker
Messages: 1
Registered: June 2001
|
Junior Member |
|
|
New to SQL - Would like to know if I can search for
indexes using the SELECT statement just to verify their
indexes?
|
|
|
|
| Re: SELECT STATEMENT [message #374557 is a reply to message #374556] |
Mon, 18 June 2001 13:49  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
For your tables, select details from user_tables. For indexes, query user_indexes.
When you write a select statement and select columns from a table which correspond to the columns in an index on that table and order by the columns in the index in the oreder in which they appear in the index, then oracle retrieves the result directly from the index without even accessing the table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
