Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
Tony Rogerson wrote:
>>Can you show me an example of this ?
This example is a little trite, in that the function used returns a known data type - int. So presumably the optimizer can gather stats on this column (and index) as it would any other int column in the database - there are a known range of values, after all. Also, the column (in this example at least), has been presisted in the table.
My question was a little more complicated than that - an index on a column that is computed using a regex expression. It's still deterministic, and can still be persisted. But now the optimizer has a much harder job to gather and evaluate a range of stats. Received on Sun Feb 12 2006 - 20:50:03 CST