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's the difference between DB2 active log and archive log? Thanks a lot...
What is the picture clause of the null indicator variable?
What types of tables are there in the db2 database?
What is dbrm library?
how to check the table is empty or not?
cursor with hold explain ?
How to resolve -502 sql code in DB2?
How do you Load a table ?? and what is Load replace ?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
Give a brief description of db2 isolation levels?
What is multi row fetch in db2?
How would you print the output of an SQL statement from SPUFI?