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 Debug a Stored Procedure?
How many index keys possible for a table
How to use old values to define new values in update statements in ms sql server?
What is lock escalation and what is its purpose?
Explain the first normal form(1nf)?
What guidelines should be followed to help minimize deadlocks?
What is the difference between dropping a database and taking a database offline?
is there a column to which a default can't be bound? : Sql server database administration
What is the function of inner join?
How many non clustered indexes there can be on table ?
How can your resolve deadlocks?
4 Answers IBM, IMS, Iron Mountain, NuWare,
What is side by side migration in 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)