| 1. |
Why Is It Not Desirable To Force Users To Make An Explicit Choice Of A Query Processing Strategy? Are There Cases In Which It Is Desirable For Users To Be Aware Of The Costs Of Competing Query-processing Strategies? |
|
Answer» In general it is not desirable to force users to choose a query processing strategy because naive users might select an inefficient strategy. The reason users WOULD make poor CHOICES about processing queries is that they would not know how a RELATION is stored, nor about its indices. It is unreasonable to force users to be aware of these details since ease of use is a MAJOR OBJECT of database query languages. If users are aware of the costs of different strategies they could write queries efficiently, thus helping performance. This could happen if experts were using the system. In general it is not desirable to force users to choose a query processing strategy because naive users might select an inefficient strategy. The reason users would make poor choices about processing queries is that they would not know how a relation is stored, nor about its indices. It is unreasonable to force users to be aware of these details since ease of use is a major object of database query languages. If users are aware of the costs of different strategies they could write queries efficiently, thus helping performance. This could happen if experts were using the system. |
|