Answer Posted / deepak dada
filter factor is a reciprocal of cardinality factor
and cardinality factor is no of distinct rec in particular
col
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is the cobol picture clause of the db2 data types date, time, timestamp?
How to rename a table in DB2 ?
How will you return the number of records in table?
What is the role of union all and union
Why select is not preferred in embedded sql programs?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is view db2?
Which are the db2 tools to protect integrity of the database?
What is dbrm? What it contains?
How do I delete a table in db2?
What is the role of schema in the db2 database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the maximum size of varchar data type in db2?
Why cursor is used in db2?
What does runstats do in db2?