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.