What is a clustered index ?
For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.
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 happens if an invalid index value is passed to a function? 29.10.08
If an invalid index is passed, the function terminates without further processing. [Explanation] Functions that use an index value always determine if the index...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...What is the difference between index and subscript ? 31.07.08
Subscript refers to the array occurrence while index is the displacement (in no of bytes) from the beginning of the array. An index can only be modified using...What is the basic difference between clustered and a non-clustered index ? 23.07.08
The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index i...What are the types of indexes available with SQL Server ? 23.07.08
There are basically two types of indexes that we use with the SQL Server. Clustered and the Non-Clustered...What’s the maximum size of a row ? 17.07.08
A transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These...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...What is the difference between TYPE 1 index & TYPE 2 index ? 26.03.08
TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retrie...What’s the difference between a primary key and a unique key? 15.06.06
Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, wher...What is index ? 16.03.06
INDEX is a general term for an ORACLE / SQL feature used primarily to speed execution an impose UNIQUENESSÂ upon certain data. INDEX provides a faster access m...