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 is SPUFI?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is the command used by TSO users to invoke DB2?
What is ALTER ?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
What are types of indexes?
What is commit in db2?
How can the duplicate values be eliminated from db2 select?
What is null indicator in db2?
How can you count the number of rows from a table tab?
Mention the location where the output received from explain statement is stored.