INSUBCONTINENT EXCLUSIVE:
Pilot fish who's a computer science professor gets a call from a former student stumped by a database problem -- one that should be pretty
easy to solve."This was not one of my most stellar students," fish admits
"It seems they had set up a database for a new state agency and the system was running very slowly."I did a small amount of consulting on
the side, so I agreed to take a look."Turns out the database is rather strangely organized
The explanation Former student tells fish it's set up for ease of data entry.And for retrieval "No problem," former student says
"We created an index for every field so you can look up anything quickly
We even created Soundex codes for every last name, and created an index for the Soundex codes too."