I'll explain my situation as briefly as possible. My group is working for another company and I'm mostly creating stored procedures for making reports.
The twist is that, last month, they decided to do some major changes, which increased a lot the time required to what before worked nicely. I don't know the details, but one of the big changes is that what used to be tables now are views that get the data from an external source. Those are defined as:
CREATE view [dbo].[eng_contra_env] as select ce_serial, ce_empresa, ce_ganado, ce_contra, ce_fecha_env, ce_fecha_rec, ce_observa from OPENROWSET('MSDASQL', '***', 'SELECT * from eng_contra_env'); GO
Also, since that change, I'm not allowed to do some basic things like indexing some tables, as my boss tells me not to do so due to those changes that the client did.
So, I'm asked to improve the performance of some procedure (which again, before the changes it finished, now it doesn't). One bit of the procedure requires me to do the following:
How am I supposed to optimize that? Also, with what I said already, how viable do you think it is to work under these conditions.
Update: Apparently they had a meeting at the client and they decided to revert these changes. Thank god!