Third party indexing solutions

Hi,
We have a 3TB oracle db. 24x7 operation with data constantly coming in to the DB. Users from all over the world use a web based applicaton to query and work on the data.

Out transaction performance is quite good but our query performance sucks. looking up by ids and some combinations of search critera return ok but some never return. We indexed the db for a lot of combinations and we materialized some views and that helped a little. So far we haven't penalized our transaction throuput but if we continue this path, our transaction performance will suffer.

We are looking into a third party indexing solutions. We are talking to Omnidex.
Third party indexing solutions claim a dramatic performance improvement for
people in our situations.

If any of you are using any third party indexing solutions on oracle, please share your experiences.

Thank you very much,
Chuck Chekuri
DBA Manager
Vizional Technologies, Inc.
Santa Monica, CA - 90405 Received on Fri Sep 19 2003 - 22:20:25 CEST