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
6208 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 do you mean by commit and rollback?

974

Who uses db2?

982

When do you specify the isolation level?

972

What is meant by union and union all?

948

What is the meaning concurrency in the db2 database?

1056

Is ibm db2 open source?

1013

What is the connection string to connect to the DB2 Database ?

1059

What is the difference between bind and rebind in db2?

1393

How will you return the number of records in table?

880

Define predicate?

1065

What is the difference between db2 and oracle?

1068

What is page size in db2?

906

How do I import a csv file into db2?

937

What is the use of with ur in db2?

997

List out the buffer pools in db2

1020