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

What are the different kinds of ssrs reports?

214


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

963


Explain what are various ways to enhance the ssrs report?

1037


When would you use it?

982


Comment,Datatypes are unlimited

2055


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1032


What is the current pricing model of SQL Azure?

104


What are the steps you must follow to hide sql server instances?

970


How to find related tables in sql server?

927


What is the main difference between ‘between’ and ‘in’ condition operators?

1177


What is the use of nvl work?

990


How can a user-defined datatype be created?

983


What is parameterized reports in ssrs ?

149


How to drop an existing table?

998


Explain what are page splits? : SQL Server Architecture

1054