Show a multiplekey index for the following data below if the

Show a multiple-key index for the following data below if the indexes are on

MODEL SPEED RAM HD
1001 2.66 1024 250
1002 2.10 512 250
1003 1.42 512 80
1004 2.80 1024 250
1005 3.20 512 250
1006 3.20 1024 320
1007 2.20 1024 200
1008 2.20 2048 250
1009 2.00 1024 250
1010 2.80 2048 160
1011 1.86 2048 160
1012 2.80 1024 160


a) Speed then ram [0.5 Pt]?

b) Tam then hard-disk [0.5 pt]?

c) Speed, then ram then hard-disk [0.5 pt]?

Solution

1.Following is the query for creating multiple key index on Speed then Ram

You can fetch data on basic of this multple key index

Select * from Multi where Speed=2.20 and Ram=2048;

2. Following is the query for creating multiple key index on Ram then HD

You can fetch data on basic of this multple key index

Select * from Multi where Ram=2048 and HD>=150;

3.Following is the query for creating multiple key index on Speed then Ram then HD

You can fetch data on basic of this multple key index

Select * from Multi where Speed=2.20 and Ram=2048 and HD>=150;