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
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is drop table?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to view db2 table structure?
What is the difference between cursor and select statement?
Is db2 a mainframe database?
can we view the access paths created by dbrm ? how ? thx
What is query_cache_limit?
How to find primary key of a table in db2?
Explain the contents that are a part of dclgen.
Which components manage deadlocks in db2?
What is catalog database in db2?
what is db2 restart?
What is dclgen (declaration generator)?
What is reorg?