Interested to Buy Any Domain ? << Click Here >> for more details...
I am creating an index on Emp table Empno column,if u using
this indexed column in ur SELECT stmt. where clause,then how
do u know that yr index will be working or nor?
Thanks Advance...
- 3 Answers
- 6501 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoranjan sethy
by using SET AUTOTRACE ON EXPLAIN tool you can came to know weather such index is working or not.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we create clustered index without primary key?
How many types of cursors supported in pl/sql?
What is sqlca in powerbuilder?
Why do we use procedures?
How do I run a sql query?
Whis is not false in primary key?
What is the difference between null value, zero, and blank space?
Can we use pl sql in sql server?
What are records give examples?
How many types of primary keys are there?
What is the use of <> sql?
what tools available for managing mysql server? : Sql dba
What is sqlite format?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is normalisation in sql?
