Telephone index

[David Morrison - Corporate]

John,

I don't know about the HP environment, but on the AS/400 you can define an
index that only includes some of the records.  You should look into this,
first.

David Morrison


-----Original Message-----
From: John Pearce [mailto:jpearce@rmi.net]
Sent: Saturday, August 03, 2002 10:11 PM
To: powerh-l@lists.swau.edu
Subject: Telephone index


My users have asked that I provide an index on the telephone number field 
in a dataset.  It's presently a character field to allow notes like 
"non-pub" or "disconnected" to explain why there's no phone number.  The 
environment is HP ImageSQL and PH 8.39.  My concern is the performance 
issues created by 46,500 blank phone numbers that would be in one 
chain.  There are fewer than 1000 telephone numbers that contain notes like 
"non-pub" so that is not a concern (at least not yet).

To avoid the lengthy chain of blank telephone numbers I'm thinking about 
adding code to the PREUPDATE procedure to replace a blank phone number with 
a string consisting of a $ plus the unique six digit ID number for the 
record.  Then have a POSTFIND procedure that checks for the leading $ and 
blanks out the field for display.  Does anyone see any problems with this 
approach?

Thanks,
John
------------------------------------------------------------------
John Pearce  <jpearce@rmi.net>	| Bethesda Management Company
Speaking for only myself		| Colorado Springs, CO  USA


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.