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
Hi list
Did you make 'index' on your table?
make index like this:
CREATE INDEX index_name ON table_name(field_name);
i.e. CREATE INDEX username_index ON TableUser(username);
and you'll get result in 0.x seconds!
- Original Message -
From: "Asma Aripin" <[EMAIL PROTECTED]>
To: <[EMAIL
