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...
Answers were Sorted based on User's Feedback
Answer / 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 |
You execute your query like
explain plan for select sal from emp where empno='1224';
after that check this below one.
select * from table(dbms_xplan.display);
here u can find it'll be excuted by using index or TABLE ACCESS FULL
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Is not equal in sql?
Why schema is used in sql?
Is sql similar to python?
What is procedure function?
Explain sql data types?
Write one update command to update seqno field of a table on the basis of row number.
What is clustered index in sql?
Can we use loop in sql?
What is mutating error in pl sql?
If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 Answers HCL, TCS,
What are commit, rollback, and savepoint?
What are all different types of collation sensitivity?