Post by email@example.com
I have a table with millions of records and heavily referenced and index
are properly created, now I want to update a single it is take long time
to perform operation, Please suggest solution to optimize the
1) CREATE TABLE statement for the table.
2) CREATE INDEX statements for the table.
3) The statement you are running.
4) The output from "SELECT @@version"
Erland Sommarskog, Stockholm, ***@sommarskog.se