Re: pinning a table in memory

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 30 Nov 2002 00:24:10 +1000
Message-ID: <mFJF9.86408$g9.242343@newsfeeds.bigpond.com>

"David Sharples" <david.sharples3_at_ntlworld.com> wrote in message news:XdxF9.1137$zz5.86904_at_newsfep3-gui.server.ntli.net...
> We have a largeish table (6 million records) and the queries we have on
this
> table are a tad slow and the disk is the bottleneck.
>
> We have considered putting the table in cache (alter table xyz cache)
>
> Was wondering if this would help very much seeing as though the indexes
for
> this table is still held on disk.
>
> Any opinions??

Hi David,

Tune your queries, just tune your queries ...

Richard
>
> Thanks
>
>
Received on Fri Nov 29 2002 - 08:24:10 CST