Question 1 [20 Marks]View more random threads:
- CS507 Information System Assignment No. 03 Solution Spring...
- CS506 Assignment No 5 Solution requires January 2012
- CS604 Operating Systems Assignment No. 4 Fall 2012-13 Due...
- CS507-Information Systems Assignment No. 02 Fall 2012
- Mth401 assignment no 1 fall 2011 solution
- CS401 VU Current Assignment No. 3 idea solution Fall...
- CS614 Data Warehousing Assignment No. 03 Semester Spring...
- Assignment No. 02 Semester: Spring 2012 CS609: System...
- cs615 Software Project Management Assignment no 03 Spring...
- CS402 Assignment No.4 Spring 2011
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)