Oracle's Bitmap Index in SQL Server

Question

I've been successfully using bitmap indexes for years in Oracle environment. Now I'm working on a data warehouse project which will be hosted on SQL Server 2005. So far, I was unable to find an answer for bitmap like indexes in SQL Server.

Any Ideas?

dcp · Accepted Answer · 2009-12-15 19:43:48Z

6

There's not really a direct equivalent. However, SQL Server has something called bitmap filtering. You can read about it here: http://msdn.microsoft.com/en-us/library/bb522541.aspx

Unfortunately, this feature seems to have been introduced in SQL Server 2008, so it probably won't help you much since you are using SQL Server 2005.

answered Dec 15, 2009 at 19:43

dcp

55.7k24 gold badges149 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle's Bitmap Index in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related