1. When I say indexes are the same - Prod and Pre- prod have same indexes

2. No i dont need ever column, I .am actually selecting on 6- 7 columns....

1. When I say indexes are the same - Prod and Pre- prod have same indexes

2. No i dont need ever column, I .am actually selecting on 6- 7 columns....

The actual query is this.. This is Production so I don't think I can change the query it self. The same query with NoLock and same number of rows works...

populating that column will need a join between the 2 linked servers which can be even more costly...

But i can create a new table with just the zipcode and unique...

But in this way I will have to copy zipbit column to the linbked server which will again need matching the uniquekey column for all rows.. uniquekey is a varchar..

I...

I am thinking of doing this. Please suggest if this will work or not..

the 100 table make about 100 GB. This is what I am planning to do.

Step 1. Copy...

thanks a ton for replying.

In given stuation where there is no login do you think Mike will be able to have READ Access to databse. I have asked him and...

I think my question was too dumb or just did not make sense because i dint get a single reply. Please guy help me out. Any hint could be helpful

All the 11 views use 3 - 4 tables and yes 1 - 2 views also . These are common for all the 11 views.

I know the data is huge...

Thanks for showing interest in my question

Yeah i know that is a lot of data to go through. The 11 views all have sumarized data.

I created 11 smaller views since...