roysched is defined as follows:
create table roysched title_id tid not null references titles(title_id), lorange int null, hirange int null, royalty int null)
Its nonclustered index for the title_id column is defined as:
create nonclustered index titleidind on roysched (title_id)
Table B-9 lists the contents of roysched:
title_id |
lorange |
hirange |
royalty |
---|---|---|---|
BU1032 |
0 |
5000 |
10 |
BU1032 |
5001 |
50000 |
12 |
PC1035 |
0 |
2000 |
10 |
PC1035 |
2001 |
3000 |
12 |
PC1035 |
3001 |
4000 |
14 |
PC1035 |
4001 |
10000 |
16 |
PC1035 |
10001 |
50000 |
18 |
BU2075 |
0 |
1000 |
10 |
BU2075 |
1001 |
3000 |
12 |
BU2075 |
3001 |
5000 |
14 |
BU2075 |
5001 |
7000 |
16 |
BU2075 |
7001 |
10000 |
18 |
BU2075 |
10001 |
12000 |
20 |
BU2075 |
12001 |
14000 |
22 |
BU2075 |
14001 |
50000 |
24 |
PS2091 |
0 |
1000 |
10 |
PS2091 |
1001 |
5000 |
12 |
PS2091 |
5001 |
10000 |
14 |
PS2091 |
10001 |
50000 |
16 |
PS2106 |
0 |
2000 |
10 |
PS2106 |
2001 |
5000 |
12 |
PS2106 |
5001 |
10000 |
14 |
PS2106 |
10001 |
50000 |
16 |
MC3021 |
0 |
1000 |
10 |
MC3021 |
1001 |
2000 |
12 |
MC3021 |
2001 |
4000 |
14 |
MC3021 |
4001 |
6000 |
16 |
MC3021 |
6001 |
8000 |
18 |
MC3021 |
8001 |
10000 |
20 |
MC3021 |
10001 |
12000 |
22 |
MC3021 |
12001 |
50000 |
24 |
TC3218 |
0 |
2000 |
10 |
TC3218 |
2001 |
4000 |
12 |
TC3218 |
4001 |
6000 |
14 |
TC3218 |
6001 |
8000 |
16 |
TC3218 |
8001 |
10000 |
18 |
TC3218 |
10001 |
12000 |
20 |
TC3218 |
12001 |
14000 |
22 |
TC3218 |
14001 |
50000 |
24 |
PC8888 |
0 |
5000 |
10 |
PC8888 |
5001 |
10000 |
12 |
PC8888 |
10001 |
15000 |
14 |
PC8888 |
15001 |
50000 |
16 |
PS7777 |
0 |
5000 |
10 |
PS7777 |
5001 |
50000 |
12 |
PS3333 |
0 |
5000 |
10 |
PS3333 |
5001 |
10000 |
12 |
PS3333 |
10001 |
15000 |
14 |
PS3333 |
15001 |
50000 |
16 |
BU1111 |
0 |
4000 |
10 |
BU1111 |
4001 |
8000 |
12 |
BU1111 |
8001 |
10000 |
14 |
BU1111 |
12001 |
16000 |
16 |
BU1111 |
16001 |
20000 |
18 |
BU1111 |
20001 |
24000 |
20 |
BU1111 |
24001 |
28000 |
22 |
BU1111 |
28001 |
50000 |
24 |
MC2222 |
0 |
2000 |
10 |
MC2222 |
2001 |
4000 |
12 |
MC2222 |
4001 |
8000 |
14 |
MC2222 |
8001 |
12000 |
16 |
MC2222 |
8001 |
12000 |
16 |
MC2222 |
12001 |
20000 |
18 |
MC2222 |
20001 |
50000 |
20 |
TC7777 |
0 |
5000 |
10 |
TC7777 |
5001 |
15000 |
12 |
TC7777 |
15001 |
50000 |
14 |
TC4203 |
0 |
2000 |
10 |
TC4203 |
2001 |
8000 |
12 |
TC4203 |
8001 |
16000 |
14 |
TC4203 |
16001 |
24000 |
16 |
TC4203 |
24001 |
32000 |
18 |
TC4203 |
32001 |
40000 |
20 |
TC4203 |
40001 |
50000 |
22 |
BU7832 |
0 |
5000 |
10 |
BU7832 |
5001 |
10000 |
12 |
BU7832 |
10001 |
15000 |
14 |
BU7832 |
15001 |
20000 |
16 |
BU7832 |
20001 |
25000 |
18 |
BU7832 |
25001 |
30000 |
20 |
BU7832 |
30001 |
35000 |
22 |
BU7832 |
35001 |
50000 |
24 |
PS1372 |
0 |
10000 |
10 |
PS1372 |
10001 |
20000 |
12 |
PS1372 |
20001 |
30000 |
14 |
PS1372 |
30001 |
40000 |
16 |
PS1372 |
40001 |
50000 |
18 |