Re: Can anyone help with PL/SQL?

You are basically suggesting that you can create with PL/SQL a better indexing system
than Oracle can??? Create an index on the table with the appropriate columns. You should
select a different table space for the index than the main data storage perferrably on a
different physical spinal on a separate controller.

If the index is extremely unique -- you may consider a hashed index

Mike Krolewski

Sean Dolan 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.
>
> Much Appreciated,
> Sean Dolan
> Sr Systems Engineer, 3Si
> MCSE, MCP + Internet
Received on Wed May 20 1998 - 08:20:51 CEST