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

What are some characteristics of columns that benefit from

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

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,