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 are the full forms of spufi and dclgen and why are they used?
How can record locking be achieved in those DB2 versions which do not support it?
What is collection in db2 bind?
What is rct?
What is a Foreign Key?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How to retrieve rows from a db2 table in embedded sql?
Explain packages.
What is host variable in db2 cobol?
How to resolve deadlock issue
What is dbrm in db2 database?
How to find primary key of a table in db2?
What is the difference between nvl and coalesce?
What are host variables in db2?
What is netezza database?