Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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...

Question Posted / ajit

Answers were Sorted based on User's Feedback



I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt...

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

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt...

Answer / 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

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt...

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

Post New Answer

More SQL PLSQL Interview Questions

How to test for null values?

0 Answers  

What is normalization sql?

0 Answers  

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

How do I copy a table in sql?

0 Answers  

What is data definition language?

0 Answers  

What is partition in sql query?

0 Answers  

Should I use mbr or gpt?

0 Answers  

What are local and global variables and their differences?

0 Answers  

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 is the Subquery?

4 Answers  

What sql database should I use?

0 Answers  

How to return an array from java to pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories