Hi,
Instead of using separate "CREATE INDEX" statements, you can build all
your index at once with "ALTER TABLE":
ALTER TABLE my_table
ADD INDEX ...,
ADD INDEX ... ,
ADD INDEX ... ;
Hope this helps,
--
Joseph Bueno
Salvesen, Jens-Petter wrote:
> Hello, everyone
>
> I have the following
Hello, everyone
I have the following situation:
After "enjoying" problems related to deleting a large portion of a table,
subsequent slow selects and such, I decided to do an alternate route when
removing data from a table:
The table had transactions for one year, and the table really only needs
