What is an Index and its Types and Differences between them ?

What is an Index?

Indexing is a mechanism which makes record
fetching faster. It does this by having pre-sorted the rows of the table.

Types of Indexes:

1. 
   
   Clustered.
   
   
2. 
   
   Non-Clustered.

Sno	Clustered	Non - Clustered
1	It reorders the physical storage of records in the table.	It sorts and maintain a separate storage.
2	There can be only one Clustered index per table.	More than one.
3	The leaf nodes contain data	The leaf node contains pointer to data

What is an Index and its Types and Differences between them ?

What is an Index?

Indexing is a mechanism which makes record
fetching faster. It does this by having pre-sorted the rows of the table.

Types of Indexes:

1. 
   
   Clustered.
   
   
2. 
   
   Non-Clustered.

Sno	Clustered	Non - Clustered
1	It reorders the physical storage of records in the table.	It sorts and maintain a separate storage.
2	There can be only one Clustered index per table.	More than one.
3	The leaf nodes contain data	The leaf node contains pointer to data

Win Rs 70000 by participating in DesignChef.com Contest

Win Rs 70000 by participating in DesignChef.com Contest


for more details,


www.designchef.com

Win Rs 70000 by participating in DesignChef.com Contest

Win Rs 70000 by participating in DesignChef.com Contest


for more details,


www.designchef.com

Win prizes worth $3000 by participating in CodeChef's Contest

CodeChef July Contest - Win prizes worth $3000




http://www.codechef.com/JULY09

Win prizes worth $3000 by participating in CodeChef's Contest

CodeChef July Contest - Win prizes worth $3000




http://www.codechef.com/JULY09

Daily Tips- Tip #3 - Automatically closing a connection after datareader finishes execution

To automatically close a connection after datareader finishes execution, you need to specify the CommandBehaviour.CloseConnection parameter to the command object, as


drEmployees = cmdEmployees.ExecuteReader(CommandBehaviour.CloseConnection);