1
Answer

Improve the performance of an Query.

Raghavendar S

Raghavendar S
3y
537
1
When we select data from multiple tables millions of records. how to improve the execution process?
 
My Answer: 1)Don't Use * when we use select statement, instead of * use the required columns.
 2) Add an index to the columns.
3) avoid the union  
Answers (1)
Next Recommended Forum