Mikko Noromaa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 03, 2002 9:11 AM
Subject: INSERT performance when indexes are used
> Hi,
>
> I have a table with about 5 million records, and an index on that
> table's VARCHAR(255) field, as well as a c
Hi,
I have a table with about 5 million records, and an index on that
table's VARCHAR(255) field, as well as a couple of integer indexes. The
VARCHAR-index is essential to my application as I frequently need to
search through the whole table by using the VARCHAR field.
When I do INSERTs into thi
Hi,
I have a table with about 5 million records, and an index on that
table's VARCHAR(255) field, as well as a couple of integer indexes. The
VARCHAR-index is essential to my application as I frequently need to
search through the whole table by using the VARCHAR field.
When I do INSERTs into thi