>I have 50000 records in my master table which I want to load in a third party combo box at run time(as per criteria provided). So I have bounded that control to increase the speed, but steel its taking 1 to 2 min's to load all values. I have also done indexing on that particular table.
>
>Can anyone please suggest me the better way to increase the speed.

I cannot imagine how users will work with 50000-items combobox. I think you need to redesign application in that part.