solution of sql server
|
|
|
Question / Problem
|
what types of index data structure u have?
|
Solution
|
An index helps to faster search values in
tables. The three most commonly used index-types are: - B-Tree: builds a tree
of possible values with a list of row IDs that have the leaf value
Needs a lot of space and is the default index
type for most databases. - Bitmap: string of bits for each possible value of
the column.
|
Applies to |
|
Microsoft SQL Server 2005
|
Rank It |
|
