Dear friends,
I have a large database that more than 18million records. I want fetch some records from it. But it very slow. I wait for about 5 minutes before it appear. The sql statement is "select name from billing where time <10". How can I promote the speed. Pls help. Thank you.
I have a large database that more than 18million records. I want fetch some records from it. But it very slow. I wait for about 5 minutes before it appear. The sql statement is "select name from billing where time <10". How can I promote the speed. Pls help. Thank you.