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

Ian Michael Gumby wrote: > > > > Date: Mon, 2 Feb 2009 14:46:06 +0000 > > From: obnoxio@serendipita.com > > > > Then your index on bar will be used and everyone is happy. > > > > Everyone except the guy who has to make absolutely sure that bar does, > > in fact, equal UPPER(foo). Whereas, if you use a functional index, you > > don't have to worry about that. > > > > Hmmm, a clown who can't pull the trigger? ;-) > Or handle constraints? > > What happens when your offshore team forgets to use my_func() > and writes the query... > > WHERE foo = UPPER(?) and expects it to work? If it's coded into the application, it's hardly a problem. It will happen once or twice, be felt by the user, moaned about and then get fixed. But if your trigger has a problem, the problem might remain hidden for years, gradually corrupting data and reducing the value of the system to the business. > For every solution there is a trade-off. Indeed. -- 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.