Question 1 [20 Marks]View more random threads:
- CS502 Fundamentals of Algorithms Assignment No .4 Solution...
- Eng201 assignment no 3 solution fall 2010
- CS601 Data Communication Assignment No. 03 Solution 23rd...
- MTH401 Differential Equations Assignment No.1 Solution...
- CS408 assignment no 4 fall January 2012
- MGT503 - Principles of Management Assignment No. 1 Semester...
- STA301 Assignment No.3 solution Fall 2010 (Total Marks 30)
- CS401- Computer Architecture and Assembly Language...
- CS504 Software Engineering-1Assignment no 2 Fall 16...
- MTH301 Calculus II Assignment No.3 Solution Fall Semester...
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)