How does DB2 use multiple table indexes ?
DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.
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
What type of Indexing mechanism do we need to use for a typical datawarehouse ? 23.09.08
On the fact table it is best to use bitmap indexes. Dimension tables can use bitmap and/or the other types of clustered/non-clustered, unique/non-unique indexes...How can I perform a nonlogged bulk copy ? 22.07.08
The following conditions should be met for nonlogged bulk copy: The database option select into/bulkcopy is set to true using sp_dboption. The target table...How can we plan storage for very large tables? 23.05.08
Limit the number of extents in the table Separate the Table from its indexes Allocate sufficient temporary storage...List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance ? 08.05.08
SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operat...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...How many clustering indexes can be defined for a table ? 18.03.08
Only one....Lot of updates have been done on a table due to which indexes have gone haywire. What do you do ? 17.03.08
Looks like index page split has occurred. DO a REORG of the indexes....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,...What are indexes? 12.03.06
Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field...What is the use of INDEXES option in EXP command ? 12.03.06
A flag to indicate whether indexes on tables will be exported....