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 |
Please tell me some knowledge about Clustering and how to add clustering?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How many nested transaction can possible in sql server?
What is 'Join' and explain its various types.
How to list all schemas in a database?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is sql language?
What is a synonym for manipulation?
Can we execute a stored procedure inside a trigger?
6 Answers BirlaSoft, CarrizalSoft Technologies, United Healthcare,
Describe in brief sql server monitoring ways.
What is key attribute?
Differentiate between a primary key and a unique key.
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)