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 |
What will the FREE command do to a plan?
What happens in bind step in a db2 program?
What is drop table?
What is blu acceleration in db2?
How to resolve -803 sql code in DB2?
On which levels locks can be applied?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is dclgen (declaration generator)?
How do you define a correlated name?
how we will do null data selection in cobol-db2 program
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is the difference between cursor stability and repeatable read isolation levels?