Asma,
Friday, July 12, 2002, 2:15:42 PM, you wrote:
AA> does it means when a column has an index, the records inside will no longer
AA> duplicate?
Nope. It will be true if you create _unique_ index or primary key. If
you create 'simple' index column can contain duplicated records.
http://w
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:
>|
>
-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 t
Asma Aripin <[EMAIL PROTECTED]> writes:
> --
> 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 decrea
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 12, 2002 2:41 PM
Subject: Processing Time
>
>
>
> --
> I want to select 1 record from 200,000 rows of records. I use this SQL
> statement:
>
> SELECT password FROM Tabl
--
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
