Re: Processing Time

2002-07-12 Thread Asma Aripin
does it means when a column has an index, the records inside will no longer duplicate? if so, i can't put an index to that column because that record need to be duplicate At 05:50 AM 7/12/02 -0500, Mark Matthews wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >

Processing Time

2002-07-11 Thread Asma Aripin
-- I want to select 1 record from 200,000 rows of records. I use this SQL statement: SELECT password FROM TableUser WHERE username='jack00' It takes me about 20 seconds just to view the password. Is there any other way to decrease the time? (In about less then 1 second) -- T