Question 1 [20 Marks]View more random threads:
- cs 615 Software Project Management Assignment # 01 Spring...
- cs504 assignment no 1 Spring 2011 idea solution of software...
- MGT201 Financial Management Spring 2011 GDB 1 Idea Solution...
- CS506 Web Design and Development Assignment No. 04 SEMESTER...
- cs201 assignment no 1 spring 2012 idea solution on April...
- MTH401 Differential Equations Assignment No 4 Solution Fall...
- cs615 assignment no 3 spring 2011 idea solution
- CS504 - Software Engineering Discuss about 4th Assignment...
- CS709 Formal Methods for Software Engineering Assignment No...
- CS301 Data structures ASSIGNMENT No.3 Fall Semester 2012...
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)