which tables to cache ?

From: Bunyamin K.Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Sat, 28 Apr 2001 08:09:52 -0700
Message-ID: <F001.002F4EB8.20010428073533@fatcity.com>

    I am planning to cache some

tables in my database butI can not decide on them.

    I have 5 big tables ,150 small

tables. these 5 big tables sum is bigger than total size of database buffer cache.
    Is it good to cache them because

I have so much complex views collecting data from these big tables.??

Bunyamin K.Karadeniz    Database
Group / Information Systems Department     HAVELSAN Ankara /TURKEY    Tel : +903122873565 / 1681    Mobile Tel : +90 535 3357729

Received on Sat Apr 28 2001 - 10:09:52 CDT