Can you define an Index if the table size less than 10
PAGES?
- 1 Answers
- 5785 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 host variable in db2 cobol?
What is the role of schema in the db2 database?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Define predicate?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a db2 tablespace?
What is table space in db2?
On which levels locks can be applied?
What is lock escalation in db2?
Which component is responsible for processing sql statements and selecting access paths?
What is the use of runstats in db2?
Explain about rct.
Where can you declare a cursor in a cobol-db2 program?
What is ibm db2 database?
What is null indicator in db2?
