whats the explain plan, have you traced it to find what you are waiting on?

plus hardly anyone where will know what a 'lakh' is