You do not want to define an index on such a small table because, its an

Can you define an Index if the table size less than 10
PAGES?

Question Posted / s

1 Answers
6301 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

Please Help Members By Posting Answers For Below Questions

What is the use of dclgen in db2?

1082

What is the difference between db2 and oracle?

1125

What is database reorganization?

1123

What is bind in db2?

1036

How to rename a table in DB2 ?

1086

What is a page in db2?

1025

Is db2 a mainframe database?

996

What is the clustering index in the db2 database?

1001

Explain about rct.

1085

Explain in brief how does db2 determine what lock-size to use?

1036

Explain db2.

1031

What is cascading rollback?

1209

What is the difference between plan and package in db2?

1106

What are the contents of dclgen?

1103

What is dpf in db2?

1103