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
6228 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

How can we read records for specific member in CL? AND rpg?

656

What is a Foreign Key?

1047

How to execute stored procedures?

1070

What are concurrency issues?

1041

What is the use of runstats in db2?

1039

How can you classify the locks in db2?

1041

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

What is runstats db2?

969

What is the use of predicate?

994

What are foreign keys in db2?

1048

How do I add a column in db2?

1008

Explain about rct in db2?

1056

What are types of indexes?

1006

What is schema in db2?

975

What is cloudant database?

1048