On Tue 18 May 02004 at 02:03:55PM -0500, Victor Pendleton wrote: > From this explain plan it appears a full table scan will be done. What is > the cardinality of this index? >
Actually, they are phone numbers. I wasn't sure how this list would feel about this but I am wring a National Do-Not-Call Registry complaince tool for internal use at my company. We are a real estate agency, not telemarketers. We don't make a ton of cold calls but we don't want to get sued either. My table contains all do-not-call entries in Massachusetts. They are inserted in numeric order. Would it be faster if I broke it into columns for area code, exchange, and subscriber? -- Jacob Elder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
