How can we improve the data retrival speed?

  • Interview Candidate
  • 6
  • 1415

Showing Answers 1 - 6 of 6 Answers

chenw2000

  • Jul 11th, 2008
 

the first thing I can think of is to do indexing

second, modify the table structure to reduce the possible comparison like "where col like '%AA%'

third, modify the query to retrieve less rows of intermediate data.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions