Question 1 [20 Marks]View more random threads:
- Cs401 Assignment no 5 fall January 2012 solution
- cs601 assignment no 1 April 2012 Due date 19 April 2012
- CS504 Software Engineering-1 Assignment no 3 semester fall...
- CS615 Assignment No. 05 Spring 2011 idea Solution
- CS403 assignment no 5 fall 2010 solution on 29/01/2011
- MTH202 - Discrete Mathematics Spring 2011 Assignment no 1...
- cs302 assignments no 01 Solution spring October 2011
- cs601 Assignment no 5 idea solution Spring June 2011
- CS301‐ Data Structures Assignment No. 01 Spring 2013
- cs501 first assignment fall 2010 Solution
Consider the following table:
Player_Country
Player_ID
Player_type
Country_name
IND-01
Wicket Keeper
India
IND-05
Bowler
India
SA-07
Batsman
South Africa
SA-09
All Rounder
South Africa
AF-01
Batsman
Afghanistan
AF-04
Wicket Keeper
Afghanistan
WI-01
Batsman
West Indies
WI-06
Spinner
West Indies
Create bitmap index for the following queries.
1) Select * from Player_Country where Player_type =”Bowler” AND Country_name=”India”
2) Select*from Player_Country where Player_type =”Wicket Keeper” OR Country_name=”Afghanistan”
Sponsored Links
There are currently 1 users browsing this thread. (0 members and 1 guests)