Re: indexing issue, need alternate solution to improve the query performance

"EdStevens" <quetico_man_at_yahoo.com> wrote in message news:1142862265.658701.105400_at_v46g2000cwv.googlegroups.com...
:
: ramprakash wrote:
: > Hi,
: >
: > i am facing a scenario like this,
: >
: > i am having a table having around 1 million rows, and 15 columns.
: > This is the logging table, mostly insertion only happens.
: > the query we use from front end uses almost any one or two of the 10
: > columns in the where condition.
: > since it a log table and insertions are heavy, i cant create index for
: > all the columns.
: > Need some alternate solution.
: >
: > Regards
: > Ram
:
: An alternate solution to what problem? All you've told is that you
: have a table, and that the table gets a lot of insert activity. So
: what's the problem you think you have? And why to you think it is a
: problem.
:
: Oh yeah, what version of Oracle and what OS?
:

ramprakash,

when are/must the queries against the table be run?

can you periodically replicate the table to another schema or database and run reports there rather than on the OLTP version of the table?

++ mcs Received on Mon Mar 20 2006 - 07:59:41 CST