Can you define an Index if the table size less than 10
PAGES?
Answer / s
You do not want to define an index on such a small table
because, its an overhead to maintain the index and
tablespace scan will only result in 1 I/O.
Is This Answer Correct ? | 6 Yes | 2 No |
What do you mean by between and in? Is between inclusive of specified range values?
is there any restrictions for unions ?
What is DB2 (IBM Database 2)?
How to find the maximum value in a column in the db2 database?
What are leaf pages?
How can you get the number of rows impacted by the last executed query?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
What is temporal table in db2?
What do you mean by NOT NULL? When will you use it?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
How is deadlock resolved?
what are stage one indexable predicates?