Can you define an Index if the table size less than 10
PAGES?
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
If I have a view which is a join of two or more tables, can this view be updateable?
What is db2 command?
What is blu acceleration in db2?
What is db2 catalog database?
What is copy pending status in db2?
What is a db2 collection?
What is performance tuning db2?
Can we delete records from view?
How to test SQL -911 error while developing COB-DB2 program
What is the difference between bind and rebind in db2?
How can you find out the # of rows updated after an update statement?
i want to maintain uniqueness on pdf without make lf??????????
What is collection in db2 bind?
What is cursor stability in db2?
What is the role of data manager in the db2 database?