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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between plan and package in db2?

1057

What is the physical storage length of time data type?

1077

Is db2 relational database?

931

What is the maximum No of rows per page?

1024

What is runstats utility in db2?

970

What is consistency token in db2?

1082

What is bind plan?

994

How do I copy a table in db2?

959

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1152

When reorg is used?

1083

What is phantom read in db2?

1090

What are the various data types available in db2?

1029

Which are the db2 tools to protect integrity of the database?

1082

List out the buffer pools in db2

1031

How many databases can be created inside an instance in db2 ?

994