Explore BrainMass

Explore BrainMass

    Query processing strategy

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Why is it not desirable to force users to make an explicit choice of a query processing strategy? Are there cases where it is desirable for users to be aware of the costs of competing query-processing strategies? Please explain.

    © BrainMass Inc. brainmass.com October 10, 2019, 5:12 am ad1c9bdddf

    Solution Preview

    Dear Student,

    The basic ingredients of the query decomposition are

    (1) To discover pieces of a query which are joined to the remainder by a single joining variable

    (2) To substitute for a variable. The overall strategy is to break up a query at the joining variables whereever possible, and to select a variable for substitution, which incurs a "cost" wherever substitution can no longer be ignored.

    For simple queries, elaborate optimization may well do more harm ...

    Solution Summary

    The expert examines query processing strategies.