Re: {Spam?} RE: Creating index with upper function

Posted in 2009

Obnoxio The Clown — Sun, 01 Feb 2009 17:27:12 +0000 — source: Usenet: comp.databases.informix

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.