Date: Thu, 17 May 2001 12:54:04 -0400
Reply-To: Jonathan Siegel <Jonathan.Siegel@PFIZER.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jonathan Siegel <Jonathan.Siegel@PFIZER.COM>
Subject: Re: sas compression for large tables and indexes
Bill Inmon has a good discussion of this in Data Warehouse Performance.
Bill explains that most DBMSs (and indexing schemes) are designed to
facilitate transactions that retrieve and work with individual records.
Decision Support Systems -- SAS's bread and butter -- work in whole tables,
and their performance is a different ball game.
>From: David L. Cassell [mailto:Cassell.David@EPAMAIL.EPA.GOV]
>Sent: Wednesday, May 16, 2001 10:01 AM
>You'll just have to try it yourself. But expect that - compressed or not -
>you will see slower times accessing the entire dataset using indices than
>accessing the entire dataset without.
>David Cassell, CSC
>Senior computing specialist