Interested to Buy Any Domain ? << Click Here >> for more details...
Can you define an Index if the table size less than 10
PAGES?
- 1 Answers
- 6313 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between bind and rebind in db2?
How to get the ddl of a table in db2?
What is phantom read in db2?
What is view db2?
List out the buffer pools in db2
What is the maximum length of sqlca?
Why cursor is used in db2?
How do we specify index to include or not during bind process.
What is the difference between cursor and select statement?
How do you pull up a query which was previously saved in qmf?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is null indicator in cobol db2?
Explain how can you do the explain of a dynamic sql statement?
Which component is responsible for db2 startup and shutdown?
What is reorg?
