Re: The Need for speed

From: sPh <sphealeyxxx_at_xxxworldnet.att.net>
Date: Sat, 21 Oct 2006 00:18:02 GMT
Message-ID: <_Gd_g.320291$QM6.268669@bgtnsc05-news.ops.worldnet.att.net>

 > DA Morgan wrote:
> General Fear wrote:

>> I recently was put on a project that required me to improve the speed
>> of a pl/sql code.
>>
>> To give you an idea what I am working with, forget the 3rd normalized
>> form. This is more like 4th or 5th normalized form. Retrieving data
>> requires joining many tables with a lot of records.
>>[...]
>[...]

> Read, comprehend, and apply everything in Tom Kyte's and Jonathan
> Lewis's books.
> Set SPEED=REALLYFAST in your init.ora
>
> Generic questions beget generic advice.
> No version.
> No indication of transaction volume, size, type, etc.
> No PL/SQL
> No explain plan generated with DBMS_XPLAN
> No profile generated with DBMS_PROFILER
>
> We don't know whether your PL/SQL is calculating the trajectory of the
> Mars orbiter, loading music DVDs as BLOBS, or part of an ERP application.

Daniel,
You forgot one:

Databases are _designed_ to join "many tables".

sPh Received on Fri Oct 20 2006 - 19:18:02 CDT