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
- 6732 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
How to write html code in pl sql?
What is a sql statement?
What is the use of non clustered index?
what are date and time intervals? : Sql dba
Which normal form is best?
What is a call statement? Explain with an example.
what is error ora-03113: end-of-file on communication channel?
what is a record in a database ? : Sql dba
What is trigger with example?
What is a primary key called that is made up of more than one field?
What are the types of optimization?
What is the purpose of the partition table?
What type of database is sql?
What is difference between cursor and trigger?
How many types of sql are there?
