seminewbee2005
Instructor
oes sql server have bitmap indexes like Oracle?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
does sql server have bitmap indexes like Oracle?
- Thread starter seminewbee2005
- Start date
- Status
jbenson001
Programmer
SQL Server has an Image data type for colums. I assum this is what you are referring to. You cannot index on this type of column. SQL Server does also have a binary type for columns which you can index on.
Unfortunately SQL Server doesn't allow the user to Create a bitmap index (Bitmap indexes are a highly compressed index that is not structured as a Btree). However if you look at Query plans you will see where the SQL Optimizer will create Bitmap Indexes as part of the Query execuion plan.
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
- Status
Similar threads
- Locked
- Question
- Locked
- Question
