Performance issue with selection of data on a table

Latheesh,

Thanks..

300k is the total records in the table as of now it can go upto billions. Filter conditions are not required i have to select all the data form the table and DISTINCT and ORDER BY are mandatory. Hope that clears my issue.

Let me know if more information is required.

Regards,Eshwar.

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.