Thanks Grant & Anthony. Will try those options. Thanks a lot.

Okay. Thanks Grant.

Thanks Jeff & Grant for nice words. I feel good.

Hi Steve, I have gone through this article but my case is not considered. That's what I have said it in my inital post with that WHERE condition.

Why not retain index 2 and drop index1 and index3?

Thanks Lynn. One follow up question. How does the schema of the tables make a difference in creating an index?

Any suggestions please?

Thanks Thom.

Thanks John and Tom. Thank you for the detailed explaination.

Thanks Jason.

Always the first row will be a bunch of characters indicating a header and date in "YYMMDD" format , again some sort of file creation date in "YYMMDD" And a ...

Hi Thom and Phil,
Key is record number will be unique... its an ever increasing value... it my bad that i havent mentioned it.
Also, editing the original...