Re: Can anyone help with PL/SQL?

Sean:

We have done stuff like this but we placed the redundant info right in the base table as redundant colunms, then indexed the new columns.

Have you looked at the explain plan to make sure you aren't doing somehting silly like scanning the big table?

Paul Dorsey
Dulcian, Inc.

Sean Dolan <sdolan_at_3si.com> wrote in article <01bd7e79$b7a61760$1565a8c0_at_sdolan.3si.com>...
> 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.
>
> Much Appreciated,
> Sean Dolan
> Sr Systems Engineer, 3Si
> MCSE, MCP + Internet
>
Received on Wed May 13 1998 - 16:29:45 CEST