Answer Posted / bijaylaxmi
sql>create bitmap index <bitmap index name>
on tablename(column name);
e.g-create bitmap index empbitmapjob on emp(job);
This is the syntax for bitmap index.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is bit datatype? : Sql server database administration
Why should we go for stored procedures? Why not direct queries?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Can you name a few encryption mechanisms in sql server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Explain Geography datatype in SQL Server
What are the types of database schema? : sql server analysis services, ssas
Explain concepts of analysis services?
What are the different authentication modes in sql server? How can it be changed?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
How do I connect to sql server database?
What stored procedure would you use to view lock information?
What is the maximum size of column in sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
what is new philosophy for database devises for sql server 7.0? : Sql server database administration