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

1. what is the exact use of hint in sql.

2. How we can avoid index scan in sql even though index is
there in the table.

Question Posted / durgesh kumar behera


1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index ..

Answer / karkuvelrajan muthusamy

1. Hints instructs the optimizer to generate the explain
plan as hinted rather than the optimizer choosing its own
explain plan..

2. There are many ways like disabling the index usage by
implementing a function or an operation on the indexed
column OR giving a FULL hint in the query for that
particular table etc

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

Is it possible for a table to have more than one foreign key?

0 Answers  

How many sql commands are there?

0 Answers  

What is sql and its types?

0 Answers  

How can I tell if sql is running?

0 Answers  

What is the current version of postgresql?

0 Answers  

Can a key be both primary and foreign?

0 Answers  

How do I view a procedure in sql?

0 Answers  

How do you determine the current isolation level? : Transact sql

0 Answers  

What is a scalar value in sql?

0 Answers  

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

What is the left table in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories