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 is cursors? And what are the different types of cursor?
Why foreign key column allowing null values even a parent tables reference key column not having null value..
How to use "begin ... End" statement structures in ms sql server?
What are functions
How do you measure the performance of a stored procedure?
What are explicit and implicit transactions?
Explain ms sql server reporting services vs crystal reports?
Differentiate between SQL and ORACLE joins and write their syntax.
What do you mean by a Composite primary key?
What is the process of indexing?
What is a fill factor?
Name 3 ways to get an accurate count of the number of records in a table?
Oracle (3253)
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)