What DB2 Catalog column tell you when an index needs table reorganized ?
The FAROFFPOS column of the SYSIBM.SYSINDEXPART table.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
There are at least seven IDCAMS commands; name and explain each of them ? 11.08.08
ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, of course. DEFINE is used for ALTERNATEINDEX,...What is an index key ? 28.07.08
It is a column or set of columns in a table used to determine the order of index entries....What are the column name qualifiers ? 14.07.08
A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in more than one table used in the SQL stateme...Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ? 10.04.08
The catalog tables to use are the SYSIBM.SYSTABLES and the SYSIBM.SYSCOLUMNS....What are column-name qualifiers used ? 09.04.08
Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one table used in the SQL statement. C...What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run ? 09.04.08
The DBA can see this in the PERCDROP column of the SYSIBM.SYSTABLEPART catalog table....What is meant by index cardinality ? 02.04.08
The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a...What is a composite index and how does it differ from a multiple index ? 01.04.08
A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two col...In which column of which DB2 catalog would you find the length of the rows for all tables? 12.03.08
In the RECLENGTH column of SYSIBM.SYSTABLES...What are statistics, under what circumstances they go out of date, how do you update them? 15.06.06
Statistics determine the selectivity of the indexes. If an indexed column has unique values then the selectivity of that index is more,...