What are some characteristics of columns that benefit from
indexes?
Answer Posted / 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 View All Answers
What is the difference between using bind () and rebind () methods of naming class?
B37 abend during spufi?
What is dbrm? When it will be created?
What do you mean by rollback?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How can you do the explain of a dynamic sql statement?
What is dbrm? What it contains?
Explain what are the various isolation levels possible?
What is cobol db2?
What is alias in db2?
How would the varchar column remarks defined?
What is a plan and package in db2?
What is the maximum length of sqlca?
What does db2 plan contain?
Which component is used to execute the sql statements?