How many clustering indexes can be defined for a table ?
Only one.
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...Can one add columns to a table after it has been defined ? 14.07.08
Yes, one can add column to a table after it has been defined by using the SQL ALTER TABLE statement....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...How does DB2 use multiple table indexes ? 01.04.08
DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR....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 is a clustering index ? 07.03.08
It is a type of index that (1) locates table rows and (2) determines how rows are grouped together in the tablespace....What is Clustering? 26.06.06
Clustering. Sometimes called segmentation, clustering identifies people who share common characteristics, and averages those characteristics to form a "characte...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...