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
6382 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 does sqlcabc has?

1100

What is dclgen (declaration generator)?

1119

Explain what are the various isolation levels possible?

1099

what is the role of the cursor in db2?

1115

Give the name of some fields form sqlca.

1145

What is a storage group (stogroup)?

1286

What are host variables in db2?

1125

What is a plan and package in db2?

1155

Where can you declare a cursor in a cobol-db2 program?

1145

What is access path in db2?

1044

How can you count the number of rows from a table tab?

1140

What is the result of open cursor statement?

1129

What is dbrm?

1181

Is ibm db2 free?

1073

What is scrollable cursor in db2?

1126