Re: ** high water mark for small tables
Date: Mon, 27 Jul 2009 16:54:05 -0700
On Mon, Jul 27, 2009 at 3:06 PM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:
> Agreed. If you have to hit most of the table blocks, you canít beat an
> FTS. What I think Jared was getting at, is that there is (or at least used
> to be) a myth that small tables did not have to be indexed. It can easily
> be demonstrated that an index can be beneficial, even for a single-row
Also, please notice that I did not say 'must implement'.
My post said to 'give serious consideration to'.
eg. look at the access path, determine if an index is beneficial, test it, and implement it if it works.
JaredReceived on Mon Jul 27 2009 - 18:54:05 CDT