I have a table with millions of records and heavily referenced and index are properly created

[i***@gmail.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 performance.

Regards,
sourabh

[Erland Sommarskog]

Post by i***@gmail.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
performance.

Please post:

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"