Interested to Buy Any Domain ? << Click Here >> for more details...
What are some characteristics of columns that benefit from
indexes?
- 1 Answers
- 4500 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
Differentiate between cs and rr isolation levels? Where do you specify them?
can we view the access paths created by dbrm ? how ? thx
What is the use of with ur in db2?
How does a cursor work?
How is a typical db2 batch pgm executed?
What is dbrm? What it contains? When it will be created?
What are the uses of db2 optimizer?
What is with ur in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is the difference between nvl and coalesce?
What is concurrency?
Explain in brief how does db2 determine what lock-size to use?
Define sqlca.
What is buffer pool and list some of them?
What is the result of open cursor statement?
