Where is the output of EXPLAIN stored?
Answers were Sorted based on User's Feedback
What is scrollable cursor in db2?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
how do u update the faltfile into db2 table ?
can we update the table by using cursors can anyone post the query?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
How to check sequence on a table in db2?
List some fields from sqlca?
explain about index with examples
What is runstats utility in db2?
Give some example of statistics collected during RUNSTATS?