Re: My one for today: ALTER TABLE foo CACHE;

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Mon, 29 Jan 2001 20:54:25 GMT
Message-ID: <954l9s$fde$1@nnrp1.deja.com>

Hi.

As I understand it - the accessed block from FOO table are placed at beginning of LRU list. That's the only difference.

HTH. Michael.

In article <954k9g$ehb$1_at_nnrp1.deja.com>, fooguy <jweisen_at_my-deja.com> wrote:
> Here's my stupid question for today.
>
> When I do a ALTER TABLE foo CACHE; what exactly happens? How does that
> affect the table in regards to read speed, write speed, what happens at
> shutdown, etc?
>
> Thanks,
> John
>
> --
> *********************************************
> "All I every wanted from life was to see
> Larry Wall give Bill Gates a Perl Necklace."
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 29 2001 - 14:54:25 CST