| Author |
Topic |
|
strong namla
Starting Member
5 Posts |
 Posted - 2010-07-14 : 18:23:06
|
| hi all how are you i have questions about the index i need to know whats all the type of index in MS SQL Server 2005 2008 all the type of indexes at the sql server databasewhen i search i found some of them and i collect it types of indexes in a MS-SQL Server database. These are: Clustered Index, Dense Index, Sparse Index, Nonclustere Index, Covering Index, Unique Index, Binary Trees Index, Composite Index, Spatial Index, ISAM (Indexed Sequential Access Method) Index and Hash Index??? Is that all the type of index in sql server?? if not tell me whats right?Please answer meto be or not to be |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-07-14 : 18:42:18
|
| There are only two types of indexes: Clustered and Nonclustered. Sometimes it is confusing because SQL implements certain constraints as Indexes (like Primary Key and Unique). |
 |
|
|
strong namla
Starting Member
5 Posts |
Posted - 2010-07-14 : 19:05:50
|
| not 2 type of indexingi collect that types from More than one source Clustered Index, Dense Index, Sparse Index, Nonclustere Index, Covering Index, Unique Index, Binary Trees Index, Composite Index, Spatial Index, ISAM (Indexed Sequential Access Method) Index and Hash Index??to be or not to be |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
strong namla
Starting Member
5 Posts |
Posted - 2010-07-15 : 08:10:32
|
| that types of an index that i collected not rightcan you tell me about all type of an index at SQL SERVER???to be or not to be |
|
|
|
strong namla
Starting Member
5 Posts |
Posted - 2010-07-15 : 08:19:51
|
quote:
Originally posted by Lamprey
There are only two types of indexes: Clustered and Nonclustered. Sometimes it is confusing because SQL implements certain constraints as Indexes (like Primary Key and Unique).
The leaf node will contain either the entire row of data or a pointer to that row, depending on whether the index is clustered or nonclustered.that means that another type coz clustered and non clustered like a basic on structure of indexto be or not to be |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-07-15 : 12:55:40
|
quote:
can you tell me about all type of an index at SQL SERVER???
Look in Books Online for SQL Server, it's installed in the same Start Menu group as the other components. There are several comprehensive entries on indexing and storage. |
|
|
|
strong namla
Starting Member
5 Posts |
Posted - 2010-07-16 : 21:44:47
|
quote:
Originally posted by robvolk
quote:
can you tell me about all type of an index at SQL SERVER???
Look in Books Online for SQL Server, it's installed in the same Start Menu group as the other components. There are several comprehensive entries on indexing and storage.
thanks but i'm still confused coz i read a lot of articles of some authors focus on two type then i collect that []last question Is this all the type of indexes on the SQL SERVER?? or i forget something???1- clustered index 2-Nonclustered Index3- unique index4- spatial index to be or not to be |
|
|
|
SD_Monkey
Starting Member
38 Posts |
|
|
|
all the type of indexing in the MS-SQL Server