Date:         Tue, 9 Oct 2001 12:49:27 -0700
Reply-To:     "Karsten M. Self" <kmself@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Karsten M. Self" <kmself@IX.NETCOM.COM>
Subject:      Re: Sort a 8GB data set
In-Reply-To:  <5C57B5DD382CD5118E8F000629F639BE04493972@smtp.que.inalco.com>;
              from PBourdages@IAG.QC.CA on Tue, Oct 09, 2001 at 03:46:39PM -0400
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature";

on Tue, Oct 09, 2001 at 03:46:39PM -0400, PBourdages@IAG.QC.CA (PBourdages@IAG.QC.CA) wrote:
> 
> Depending on the situation, you could index the dataset instead of
> sorting. The gain is sometimes worth it.

Generally only if < 10-20% of the rows are being read from the dataset,
otherwise index overload trumps.

Index size can be substantial, generally allow 10-20% on the dataset.
In this case, the tradeoff may be size for speed, but other alternatives
present themselves.

Peace.

-- 
Karsten M. Self <kmself@ix.netcom.com>        http://kmself.home.netcom.com/
 What part of "Gestalt" don't you understand?              Home of the brave
  http://gestalt-system.sourceforge.net/                    Land of the free
   Free Dmitry! Boycott Adobe! Repeal the DMCA!  http://www.freesklyarov.org
Geek for Hire                      http://kmself.home.netcom.com/resume.html

[application/pgp-signature]