Question 1 [20 Marks]View more random threads:
- GDB Solution for cs 402
- CS302 Assignment No1 idea Solution & Discussion Due Date:...
- CS615 assignment no 2 fall spring November 2011
- CS410 Visual Programming Assignment no 1 spring fall 25...
- CS501 Advance Computer Architecture assignment solution...
- CS504 Software Engineering Assignment no 4 spring June 2011
- cs506 assignment no 3 fall 2010 solution for mcs students
- CS609 Assignment no 3 Spring 2011 idea Solution
- cs301
- Human Computer Interaction CS408 assignment 2 fall 2010
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)