Re: get a unique phone # (10 digit) from a table. SLOW

1. Check your Indexes.("set explain on" and check the cost) 2. Create composite index.(if needed) 3. Check isolation level. (You should set the isolation level to "Repeatable read" or "Cursor stability"). 4. Check your lock mode.( set lock mode to wait x seconds). 5. Application design. 6. Check you logging.( buffered or not. Do you need logging at all). Good Luck! Bahram http://www.iag.net/~bsamani