VLTs: Very Large Tables – Problems, Options, THE Solution!

Kimberly Tripp

First off, what is a VLT? To be honest, it depends on your hardware (and especially memory). In my experience, many tables begin to cause performance problems when only well within double-digit GB (80GB, 90GB, etc.). But, when that table has no plans for data removal and will only get larger, you need to act, and ideally, the earlier the better. When tables have varying degrees of data criticality. When data needs to be kept indefinitely. When modification patterns significantly vary (current data is critical/volatile but older data is read-mostly and data even older is read-only) then you have a VLT that can be tuned! In this session, I’ll describe all of the problems you’ll run into along with one solution to rule them all!