Can you define an Index if the table size less than 10
PAGES?
Answer / 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 |
What are the Isolation levels possible ?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
how to get duplicate records from tables?write qurey for this?
When Can you be sure that a query will return only one row?
How does DB2 use multiple table indexes?
what is + sign and -ve sign for sql code ?
What is check constraint in db2?
What is the self-referencing constraint?
What is cursor stability?
Describe what a storage group(STOGROUP) is?
what is the name of the default db2 catalog database?
How do I copy a table in db2?