Got it resolved !!! my sql admin had blocked running of queries on large tables...