Ian Michael Gumby wrote:
>
>
> > Date: Sun, 1 Feb 2009 15:58:45 +0000
> > From: obnoxio@serendipita.com
>
> > > Does that make sense or am I missing something?
> >
> > Do you have to make a comment on every post, whether it adds value or
> > not? :o)
> >
> > --
> > Cheers,
> > Obnoxio The Clown
> >
> No,
>
> I'll leave the 'Have you tried UPDATE STATISTICS? ' question for you. :-)
>
> I think part of the problem is that I see people asking questions on how
> to do something without thinking about the actual problem they are
> trying to solve.
And functional indexes solve a lot of problems. Almost every client I
have shown the feature to wants to use a functional index on UPPER, but
can't because it's VARIANT.
--
Cheers,
Obnoxio The Clown
http://obotheclown.blogspot.com
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.