Re: Cost Vs. Rules Based Optimizers
From: NRaden <nraden_at_aol.com>
Date: 22 Jan 1995 23:15:09 -0500
Message-ID: <3fvagd$s0s_at_newsbf02.news.aol.com>
Date: 22 Jan 1995 23:15:09 -0500
Message-ID: <3fvagd$s0s_at_newsbf02.news.aol.com>
In Message-ID: <3fjhes$d5o_at_News1.mcs.com>, dmausner_at_brauntech.com (Dave Mausner) writes:
<So, overall, IMHO the optimizer is "good", but what it
<does for you in any particular situation may be "bad".
<Warehouse apps, e.g., will always and forever need
<custom SQL tuning.
Thank you. This is also true of schema generators and most GUI-builders. Most of these tools are designed for OLTP applications, and only serve to create more problems for warehouse (and their companion front-end) developers. Pay attention, entrepreneurs, there is a market out there for warehouse-oriented CASE tools!
Neil Raden
Decision Support/Data Warehouse Consulting
Envirometrics, Inc. 805.564.8672 133 E. De La Guerra St. 805.962.3895 (fax) Santa Barbara, California 93101 E-Mail: NRaden_at_aol.comReceived on Mon Jan 23 1995 - 05:15:09 CET