•For each physical file, generate
a list of logicals that can be used in the resolution
of the query
•Look at the selectivity of the
logical file to determine it's suitability for the query at
hand
•Understand the implications of
join order and the types of joins being used
•Understand the null status of
the fields in any grouping or join statements