Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Re: Tuning Nightmare - Advice Needed
>
> Mabey you could add a table that breaks up accounts into sizes and select what
> type of query you run by the size of account. It could be a table something
> like:
> ACCOUNT_ID NUMBER
> SIZE VARCHAR2 Check ('SMALL','MED','BIG')
> The web servers could suck the rows from this table into a cache and determine
> which type of query to send to the DB by the size of the account (BIG gets the
> query with use_hash and small gets the query with use_nl or vice versa). This
> should allow you more control than histograms and literals.
Received on Wed Dec 12 2001 - 11:44:27 CST