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

What are some characteristics of columns that benefit from
indexes?

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 are the full forms of spufi and dclgen and why are they used?

1091


How can record locking be achieved in those DB2 versions which do not support it?

1081


What is collection in db2 bind?

1019


What is rct?

1239


What is a Foreign Key?

1102


What is the syntax for seeing the columns and data types of a table in the db2 database?

1171


How to retrieve rows from a db2 table in embedded sql?

1395


Explain packages.

1116


What is host variable in db2 cobol?

1081


How to resolve deadlock issue

20144


What is dbrm in db2 database?

1122


How to find primary key of a table in db2?

1066


What is the difference between nvl and coalesce?

1065


What are host variables in db2?

1073


What is netezza database?

1032