Re: database design method
From: Pablo Sanchez <pablo_at_dev.null>
Date: 28 Oct 2002 07:08:14 -0600
Message-ID: <Xns92B53F6545508pingottpingottbah_at_209.189.89.243>
Date: 28 Oct 2002 07:08:14 -0600
Message-ID: <Xns92B53F6545508pingottpingottbah_at_209.189.89.243>
"rkc" <rkc_at_spamfree.rochester.rr.com> wrote in news:0f3v9.23616$TX.8632711_at_twister.nyroc.rr.com:
> How does an application programmer optimize access to information if
> they are unaware of the existing indexes? Or is that not what is
> meant by totally transparent?
The RDBMS' optimizer handles all the optimization. This allows for a level of abstraction between the developer and the RDBMS. Furthermore, by employing stored procedures (SP's), this builds another layer of abstraction between the developer and the DBA. The SP's allow the DBA to tweak and tune the SQL, once the application is in production, without affecting the application.
-- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.comReceived on Mon Oct 28 2002 - 14:08:14 CET