syntax and example for bitmap index in sql???
Answer / 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 |
What are different types of database indexes?
What is Data model and how to prepare a data model.?
Is there any difference between primary key and unique with the not null condition?
Why foreign key column allowing null values even a parent tables reference key column not having null value..
how do u find least salary in a table
How do I connect to sql server database?
What is policy based management (pbm)? : sql server database administration
Can multiple columns be used in sql group by clause in ms sql server?
Find nth lowest salary or get nth lowest salary?
What is the parse query button used for?
Explain what are various ways to enhance the ssrs report?
How efficient you are in oracle and SQL server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)