Re: Can anyone help with PL/SQL?

On 13 May 1998 14:18:40 GMT, "Sean Dolan" <sdolan_at_3si.com> wrote:

>Good Morning,
> We are in the development stages of a large Oracle Database project and
>the task we are currently on involves creating a "pre-index" table. This
>basically is a table full of words extracted from fields within other
>tables in order to increase the speed of the queries. Queries reference
>the "pre-index" table which then tells the query what records to reference
>in the LARGE table - that way the query doesn;t have to search through the
>entire LARGE table looking for the keywords. Has anyone had experience in
>doing this? The problem, I am having is that I am doing it with a cursor
>and it is REALLY SLOW - where we only have a 2 Meg "practice" table. The
>roll-out table will be in excess of 60 Megs.

Hi Sean,

perhaps it is a good idea to have a look at the Oracle ConText Cartridge, so that you perhaps would not have to 'reinvent the wheel'.

Regards,
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net