| indexes or tablescan [message #71128] |
Wed, 11 September 2002 12:13  |
Lena
Messages: 17
Registered: August 2002
|
Junior Member |
|
|
Hi there
Can someone please tell me which is the syntax for oracle to see what is the table doing
a tablescan or indexes, I have tried select * from ... indexes but is not much help
Thanks
Lena
|
|
|
|
| Re: indexes or tablescan [message #71129 is a reply to message #71128] |
Wed, 11 September 2002 13:09  |
Eric Myers
Messages: 13
Registered: August 2002
|
Junior Member |
|
|
Lena,
You need to run an explain plan on the query to see the access path. An easy way to do this is to log into SQL*Plus and set Autotrace on (see options button) then just execute the query and the query access path will be shown after the query results. If a full table scan or index scan is happening then it will tell you that.
Eric Myers
UNC Chapel Hill
Chapel Hill, NC
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
