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 >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What are some characteristics of columns that benefit from
indexes?

Question Posted / guest


What are some characteristics of columns that benefit from indexes?..

Answer / s

primary key, foreign key, Joins are often performed on
primary and foreign key columns. columns frequently coded
in the WHERE clause, ORDER BY, GROUP BY, DISTINCT, columns
which are searched or joined over less than 5-10% of the
rows.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What does the sqlcode of -818 pertain to?

3 Answers  

What is a collection in db2?

0 Answers  

What are the isolation levels possible ?

3 Answers  

What is db2 instance?

0 Answers  

Why do we bind in db2?

0 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,

List down the types of triggers in the db2 database?

0 Answers  

What is the meaning of -805 SQL return code?

3 Answers  

What is db2 bind?

0 Answers  

What is precompiler in db2?

0 Answers  

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

what is utility for parm lib

0 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories