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 > >Asma Aripin wrote: >| >| >| >| ---------- >| 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) >| ---------- >| Thanks & Regards, >| Asma Binti Aripin >| R&D Department - [TelCo:CELCOM] >| Messaging Technologies Sdn Bhd >| Tel. (O): 0376651101 ext. 121 >| Tel. (H): 0132316056 >| Email : [EMAIL PROTECTED] >| >| ---------- > >Does the "username" column have an index? See >http://www.mysql.com/doc/I/n/Indexes.html > > -Mark >-----BEGIN PGP SIGNATURE----- >Version: GnuPG v1.0.6-2 (MingW32) >Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > >iD8DBQE9LrSFlyjUJM+7nP4RAqG3AJ9AIsBM21xf1uY0T6SghH5Uh7Ep1ACdEuxm >rVSn0yxp6hd9P0YR3cPqmcA= >=LDRV >-----END PGP SIGNATURE----- ---------- Thanks & Regards, Asma Binti Aripin R&D Department - [TelCo:CELCOM] Messaging Technologies Sdn Bhd Tel. (O): 0376651101 ext. 121 Tel. (H): 0132316056 Email : [EMAIL PROTECTED] ---------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php