PaulB (2/10/2009)
Bruce W Cassidy (2/9/2009)Try creating an index on a bit field in SQL Server 2005. Yes, it works.
Unfortunatelly that's not the concept of an Oracle bitmap index 😀
[font="Verdana"]Oh, this I know. An index of a bit (or even multiple bits) does not a bitmap index make.
Actually, the form of index I miss most from Oracle is being able to index expressions. You can sort of do this in SQL Server by creating a derived column, and then indexing the column. In both cases there are limitations to what can be indexed and what can't. But the Oracle form is very handy at times.
[/font]