Appendix B: The pubs3 Database

roysched table

The roysched table contains title id, royalty percentage, and other information about title royalties in the pubs3 table.

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)