Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: indexing issue, need alternate solution to improve the query performance

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

From: EdStevens <quetico_man_at_yahoo.com>
Date: 20 Mar 2006 05:44:25 -0800
Message-ID: <1142862265.658701.105400@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? Received on Mon Mar 20 2006 - 07:44:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US