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 are some SQL aggregates and other built-in functions?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Why do we use cursor?
What is the advantage in De-normalizing tables in DB2?
What is the difference between SYNONYM and ALIAS?
What is db2 command?
pls tell me abt the normalization five types....
How do you retrieve the data from a nullable column?
What is runstats utility in db2?
What is host variable in db2 cobol?
What is db2 plan table?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?