Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

What is copy book?

1 Answers   Thomson Reuters,


how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,


My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,


Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  


What is reorg and runstats in db2?

0 Answers  






What is dbrm library?

0 Answers  


What is the difference between CS and RR isolation levels?

1 Answers  


What is plan in cobol db2?

0 Answers  


What is image copy in db2?

0 Answers  


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


What information is contained in a SYSCOPY entry?

2 Answers  


What are the levels of isolation available with DB2V4

2 Answers   IBM,






Categories