Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

syntax and example for bitmap index in sql???

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can windows applications connect to sql servers via odbc?

1174


How do you make a trace?

1071


How many types of stored procedures are there in sql server?

1055


You are doing log shipping due to some reasons it is failing. How you will proceed from there

2115


How can you control the amount of free space in your index pages?

1100


How to retrieve error messages using mssql_get_last_message()?

1096


Explain what stored procedure sp_replcounters is used for? : sql server replication

1571


How can you find out how many rows returned in a cursor?

1079


What is use of @@ spid in sql server?

1261


How to find related tables in sql server?

998


What are the different types of normalization?

1217


What is the return type of executeupdate ()?

948


Can group by be used without aggregate functions?

961


What are wait types?

1192


Do you know what is a with(nolock)?

1102