Recent content by GJSK

I have this insert query in one of my proc to load the data into a target table where the distinct clause is making huge impact and taking too much time(since each table is having records more than 2 and 3 million records). Is their any way to optimize this select query with distinct? Insert...

Hi - I have this stored procedure which queries the remote DB tables to insert into local DB. Since it's taking hours together to run ,i decided to go with 'driving site' hint to speed up the performance.My question is how come we refer more than remote table name in the driving site hint? BEGIN...