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 are the different kinds of ssrs reports?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Explain what are various ways to enhance the ssrs report?
When would you use it?
Comment,Datatypes are unlimited
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is the current pricing model of SQL Azure?
What are the steps you must follow to hide sql server instances?
How to find related tables in sql server?
What is the main difference between ‘between’ and ‘in’ condition operators?
What is the use of nvl work?
How can a user-defined datatype be created?
What is parameterized reports in ssrs ?
How to drop an existing table?
Explain what are page splits? : SQL Server Architecture