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
- 6473 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh ramsing
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 |
Post New Answer View All Answers
Where the sql database files are stored?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is left join example?
What are the types of queries in sql?
Explain how exception handling is done in advance pl/sql?
What is java sql drivermanager?
What is nested table in pl sql?
How do temporal tables work?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is the sql case statement?
Is postgresql a nosql database?
What is sql rowcount?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is oracle pl sql developer?
When can we use the where clause and the having clause?
