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

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


what is datacom db?

2 Answers   CSC,


What are types of indexes?

0 Answers  


What is a cursor and what is its function?

2 Answers  


List out the data types available.

0 Answers  


What is copy pending status in db2?

0 Answers  


What are the functions in DB2?

3 Answers   Satyam,


What is the difference between plan and package in db2?

0 Answers  


What is the difference between static and dynamic SQL?

1 Answers  


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


What will the FREE command do to a plan?

2 Answers  


Categories