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 |
How to find the date and time of last updated table?
What are the extra roles available in msdb? : sql server security
How you provide security to cube? : sql server analysis services, ssas
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Can you please explain the difference between function and stored procedure?
Where can you find the error log information? : sql server database administration
Explain an incremental backup?
what is normalization? : Sql server database administration
Explain what are the database objects? : SQL Server Architecture
What is the dbcc command and why is it used?
Find nth lowest salary or get nth lowest salary?
What is ems sql management studio? : sql server management studio
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)