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
6324 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 are types of indexes?

1097

What is db2 instance?

1113

How do you select a row using indexes in db2?

1145

How to execute stored procedures?

1140

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2254

What is coalesce in db2?

1143

What is dclgen (declaration generator)?

1070

What is universal database?

1078

What is clone table?

1057

How to test SQL -911 error while developing COB-DB2 program

7596

What are the various data types available in db2?

1107

What are the prerogatives?

1091

What is the difference between nvl and coalesce?

1071

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

1051

How do I copy a table in db2?

1010