Re: Let me be the first
DA Morgan and Obnoxio The Clown disputed whether a phone number column would be indexed or used as a key, with DA Morgan saying searches by phone number would justify an index. Obnoxio replied with short remarks about banks and batch processing. No technical conclusion.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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.
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
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.