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
- 6620 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
Do the explain plan.if it is not using ur created index
then use hints to use ur created index
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the update statement in sql
How exception is different from error?
How many types of index are there?
Is sql procedural language?
What is cartesian join in sql?
What is clustered and nonclustered index in sql?
What is sql*plus?
How do I delete a trigger?
What are all the common sql functions?
Where do we use pl sql?
What is difference between nchar and nvarchar?
how to shutdown mysql server? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
Do ddl statements need commit?
What are stuff and replace function?
