Dave, when we pull all the fields, would it take long time and it would not use index?? I will try to add index hint. But would you please explain me why it will be a slower when we add all the columns in the query. Since i have index on the columns which are using in the WHERE clause.