Thanks Jacob for your valuable suggestion. Definitely I will try to implement it and let you know if I face any issue. Could you please tell me any other...

Its working and the result is coming with in seconds. Thanks a lot Ramesh! Thanks All!!

I am not sure whether we can use sys index to retrieve data from a linked server. The T-SQL you have provided works fine if the table is in same...

No, I expect something that can retrieve data faster. Your one will take a longer time to execute if the record count is more than 15 million.