CODEWITHSUNDEEP
sql-server-cefiltered-index
Jeremy Prine
Jeremy Prine

Reputation: 21

SQL Server Compact filtered indexes

Are filtered indexes supported in any version of SQL Server Compact?

Upvotes: 0

Views: 174

Answers (1)

anon
anon

Reputation:

I downloaded and installed Books Online for SQL Server Compact 4.0 and found no traces of filtered indexes, and the syntax diagram doesn't include a where clause:

CREATE [UNIQUE] [NONCLUSTERED] INDEX index_name 
ON table_name (column_name [ASC|DESC][,…n])
WITH (STATISTICS_NORECOMPUTE = { ON | OFF })]

So I believe the answer is, no, SQL Server Compact does not support filtered indexes. Sorry.

Upvotes: 1

Related Questions