Re: Table partitioning question

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Tue, 3 Dec 2002 15:58:48 +0100
Message-ID: <asigsm$rmp15$1@ID-152732.news.dfncis.de>

"Brian E Dick" <bdick_at_cox.net> schrieb im Newsbeitrag news:Ib2H9.66528$wc2.3063142_at_news2.east.cox.net...
> Have you done an EXPLAIN PLAN on your query?
>

Yes, long time ago ...

select statement

filter

      nested loops (outer)
         nested loops
            table access (by index rowid) person
               index (range scan) i_uname
            table access (by index rowid) adresse
               index (range scan) i_adr_pers
         table access (by index rowid) strasse
            index (unique scan) pk_strasse
      filter
         index (range scan) i_abostamm_co2

it runs fine in SQL*Plus, just as it should, but when used for a LOV in Forms,
LOV comes up only as all data are completely received by the client (different from SQL*Plus).
If you enter "Gelbrich" as a name, the LOV comes up fast since the name is rare,
but if You enter "Smith", You receive 1000 names ... that is the real problem.

I personally do not beleive that partitioning is a considerable way to solve the problem,
but I wanted to hear Your opinions ...

Yours, Jan Received on Tue Dec 03 2002 - 08:58:48 CST