Re: Performance Question

In message 6fbfu1%24o2v%241_at_list.umaryland.edu, Steve Rafferty wrote:

> I have managed to improve performance considerably, but
> so far, not enough. I am running Oracle8 Server on a
> Sun Netra with 128M of memory. I have a table with
> 90,000 rows, each of which comprise 55 fields (VARCHAR2
> mostly). The table is bibliographic records and the
> primary type of SELECT is of a regex 'like' variety.

If the 55 fields (or some subset thereof) represent attributes of the book, then you would probably be better off moving them into a separate table, one attribute per row. You could then put an index on the attribute column (and a hint in the query to use that index), significantly improving query speed (even if it has a leading wildcard, an index scan is generally faster than a table scan.

-kdg Received on Tue Mar 31 1998 - 00:00:00 CST