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
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How would the varchar column remarks defined?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is meant by union and union all?
What are packages in db2?
What is scrollable cursor in db2?
Mention data types used in db2 ?
What is db2 catalog database?
Explain about rct.
What is ibm db2 database?
What is explain in db2?
What is blu acceleration in db2?
What is the physical storage length of date data type?
What is the difference between nvl and coalesce?