මේ ගැන සිංහලෙන් ලියන්න නම් ටිකක් අපහසුයි. මන්ද මේ වදන් සිංහලට පරිවර්ථනය කිරීම තරමක් අපහසුය. ඒ නිසා ඉංහ්‍රීසියෙන්ම කියවූවනම් ටිකක් තේරුම් ගන්න පුළුවන් වේවි.

Hope you are know about Indexing and database Indexing. So SQL server 2008 introduced some new data types and also Index types. Hope you are familiar with

• Clustered
• Non clustered
• Unique
• Index with included columns
• Indexed views
• Full-text
• XML

Index types with MS SQL server 2005.In MS SQL Server 2008 they were introduced two new Index Types. It is

• Spatial
• Filtered

Simply describes Spatial in MSDN is

A spatial index provides the ability to perform certain operations more efficiently on spatial objects (spatial data) in a column of the geometry data type. The spatial index reduces the number of objects on which relatively costly spatial operations need to be applied.

and describes Filtered in MSDN is

An optimized nonclustered index, especially suited to cover queries that select from a well-defined subset of data. It uses a filter predicate to index a portion of rows in the table. A well-designed filtered index can improve query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes.

For more visit MS SQL Server 2005 Types of Indexes : http://msdn.microsoft.com/en-us/library/ms175049(SQL.90).aspx and MS SQL Server 2008 Types of Indexes : http://msdn.microsoft.com/en-us/library/ms175049.aspx