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 is copy book?
how to execute qcmdexc in rpgle?plz write code also?
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 .
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is reorg and runstats in db2?
What is dbrm library?
What is the difference between CS and RR isolation levels?
What is plan in cobol db2?
What is image copy in db2?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What information is contained in a SYSCOPY entry?
What are the levels of isolation available with DB2V4