Interested to Buy Any Domain ? << Click Here >> for more details...
What are some characteristics of columns that benefit from
indexes?
- 1 Answers
- 4678 Views
- I also Faced
- E-Mail Answers
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 a system catalog table in db2?
Mention the various locks that are available in db2.
Describe major components of db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is meant by explain?
What is db2 connect?
What does db2 plan contain?
How would you find out the total number of rows in a db2 table?
How do you select a row using indexes in db2?
What is runstats db2?
How to find the number of rows in a db2 table?
What is the maximum No of rows per page?
When the like statement is used?
How do I start db2 in windows?
What db2 400?
