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 runstats db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is bufferpool in db2?
How do I copy a table in db2?
What do you mean by cursor?
Mention the downsides of page level lock.
What is an instance database?
What are host variables in db2?
Define declaration generator (dclgen).
What is drop table?
What is image copy in db2?
Is db2 a mainframe database?
Can one database have multiple instances?
Why db2 is called db2?
Is it possible using max on a char column?