Can you define an Index if the table size less than 10
PAGES?
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 use of dclgen in db2?
How to connect to db2 database from windows command line?
Explain the contents that are a part of dclgen.
What is dbrm? What it contains? When it will be created?
What os does db2 run on?
Mention the location where the output received from explain statement is stored.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Explain the contention situations caused by locks?
How to restart a DB2 program?
What are the full forms of spufi and dclgen and why are they used?
Explain correlated sub-queries.
Why do we need reorg in db2?
How to create db2 table in mainframe?
What is the difference between drop table and delete table?
What are host variables in db2?