syntax and example for bitmap index in sql???

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


Please Help Members By Posting Answers For Below Questions

What is the latest version of microsoft sql server?

481


Explain concepts of analysis services?

506


What is the chart in report?

111


Can you explain important index characteristics?

520


How to achieve Paging of records in SQL SERVER?

592






What different steps will a sql server developer take to secure sql server?

500


How to check status of stored procedure in sql server?

443


What is the use of tempdb? What values does it hold?

563


What happens if the update subquery returns no rows in ms sql server?

587


What is bcp? When does it used?

545


Difference between uniqe index and uniqe constraint?

544


What is filter index?

514


What is collation sensitivity? Explain different types.

541


What are the types of indexes?

590


What is sharding?

88