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 |
how we will do null data selection in cobol-db2 program
what is the difference between where clause and having clause
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Suppose if I need to update a column, how you do that using cursor?
Is ibm db2 free?
What are the disadvantages of using VARCHAR?
What is DYNSLT keyword? How do you perform selection using DYNSLT
Can any one tell me about Restart logic in DB2.
How to create a table using embedded sql?
What are the three types of page locks that can be held?
How do you stop a db2 database in linux?
What is db2 catalog database?