Dear List, I have a very strange query:
The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system. It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated.