Oninit cdi / Archive
Talk to an expert →

Re: Let me be the first

Posted in 2006

Topics: General Discussion

DA Morgan — — source: Usenet: comp.databases.informix

Obnoxio The Clown wrote: > Lukas Barton said: >> scottishpoet wrote: >>> >> Yep. I update indexed column. > > At the risk of causing even more offence, I believe that to be very poor > application design. No offense taken or intended but questioning that you are responding to what was written. If searches are done by phone number it would be reasonable to index a phone number column. Are you saying you wouldn't index it or that you wouldn't let people change their phone numbers? Perhaps you meant surrogate primary keys only. -- Daniel Morgan University of Washington

↪ replying to DA Morgan
Obnoxio The Clown — — source: Usenet: comp.databases.informix

DA Morgan said: > If searches are done by phone number it would be reasonable to index a > phone number column. In a bank? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to Obnoxio The Clown
DA Morgan — — source: Usenet: comp.databases.informix

Obnoxio The Clown wrote: > DA Morgan said: >> If searches are done by phone number it would be reasonable to index a >> phone number column. > > In a bank? Depends on the country. We aren't all lucky enough to be in the UK, though I will be again in November, and not all transactions with a bank involve account numbers. Some are general inquiries that require a call back to a telephone. -- Daniel Morgan University of Washington

↪ replying to DA Morgan
Obnoxio The Clown — — source: Usenet: comp.databases.informix

DA Morgan said: > Obnoxio The Clown wrote: >> DA Morgan said: >>> If searches are done by phone number it would be reasonable to index a >>> phone number column. >> >> In a bank? > > Depends on the country. We aren't all lucky enough to be in the UK, > though I will be again in November, and not all transactions with a > bank involve account numbers. Some are general inquiries that require > a call back to a telephone. As part of their batch processing? -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.