Skip to Main Content
Data Analysis for Database Design, 3rd Edition
book

Data Analysis for Database Design, 3rd Edition

by David Howe
May 2001
Intermediate to advanced content levelIntermediate to advanced
336 pages
14h 36m
English
Butterworth-Heinemann
Content preview from Data Analysis for Database Design, 3rd Edition
 2SWLPLVDWLRQ
Fig. 18.6 shows some sample data for Student and Option tables that record which
modules each student is studying at a college. Suppose there are 500 rows in Student
and 4000 rows in Option.
The optimiser accepts a query language command (typically an SQL command, see
Chapter 19) and breaks it down into an equivalent set of relational algebra operations.
It needs to find an efficient sequence of operations, taking advantage of its knowledge
of the database storage structures and other properties of the data.
Query optimisation is a specialist subject. We will look at only a few of the options
available. In order to compare different query ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Quality Engineering in Financial Services

Data Quality Engineering in Financial Services

Brian Buzzelli

Publisher Resources

ISBN: 9780750650861