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 is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1026


What is the difference between truncate and delete commands?

1047


What is the security principal at the database level that represents your session?

921


Explain optimistic and pessimistic concurrency?

974


What are the advantages of using third-party tools?

971


What can be used instead of trigger?

1131


How many servers can we create in a single subscription?

160


What are data driven subscriptions?

112


State the difference between local and global temporary tables?

1094


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

965


What are four major operators that can be used to combine conditions on a where clause?

1025


What is conditional split?

1044


When cursors are useful?

1080


Why we use the openxml clause?

995


Mention the differences between local and global temporary tables.

1005