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
- 5918 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
Is primary key clustered index?
What is sql*plus?
Which query operators in sql is used for pattern matching?
What are tables in sql?
Why primary key is required?
What are types of indexes in sql?
What do you think about pl/sql?
what is text? : Sql dba
Explain ttitle and btitle.
What is normalisation in sql?
Is vs as in pl sql?
How do I view a view in sql?
What is sqlcontext?
how many columns can be used for creating index? : Sql dba
What is the file extension for sql database?
