When will you chose to run RUNSTATS?
Answer / deepak dada
is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base
Is This Answer Correct ? | 4 Yes | 4 No |
Name the different types of Table spaces.
what is consistency token
What is explain plan in db2?
List out the data types available.
What is a dbrm in db2?
Can any one tell me about Restart logic in DB2.
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
db2 restart logic ?
Which is faster delete or truncate?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is copy pending and check pending in db2?