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?



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

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


what is the difference between where clause and having clause

2 Answers   IBM,


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


Is ibm db2 free?

0 Answers  


What are the disadvantages of using VARCHAR?

3 Answers  


What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


How to create a table using embedded sql?

1 Answers  


What are the three types of page locks that can be held?

1 Answers  


How do you stop a db2 database in linux?

0 Answers  


What is db2 catalog database?

0 Answers  


Categories