Re: Different 'priorities' when doing selects

"Joe Smith" <nospam_at_nospam.com> schrieb im Newsbeitrag news:bodh2v$ekk$1_at_news-reader3.wanadoo.fr...
> Hi,
>
> I'm using Oracle 9i. My program is doing "heavy" calculations on some
> tables A,B, C, which require a lot of I/O, and afterwards, inserts a value
> in a table D.
> It's vital to have a decent response time when accessing this table, and
> now, when I'm in the middle of one of these calculations, I may wait for
> more than one minute to show this D table which has no more than one
hundred
> elements.
>
> Is there any way to give a higher priority to the selections in the table
D?
>
> Thx!
>

Hi, Joe,

Unfortunately You do provide almost no info to help You. I have no clue what You want to do.
But from scratch I would say, based on the few infos provided, when You make selects as a first step to show A,B,C,D, why do You not simply show D first ?
Or is it the "heavy calculations" that take so much time ?

So much from my crystal ball 8}
Jan Received on Thu Nov 06 2003 - 08:06:14 CST