Computer Science, asked by purushotam3959, 11 months ago

What Are The Steps To Take To Improve Performance Of A Poor Performing Query?

Answers

Answered by danielshivasai

0

Improve SQL Query Performance.
Avoid Multiple Joins in a Single Query. ...
Eliminate Cursors from the Query. ...
Avoid Use of Non-correlated Scalar Sub Query. ...
Avoid Multi-statement Table Valued Functions (TVFs) ...
Creation and Use of Indexes. ...
Understand the Data. ...
Create a Highly Selective Index.

pls click brainlylist

Previous Question

Next Question

Similar questions

Math, 6 months ago

please anwer pleaseeeeeeeeee...

English, 6 months ago

Dolphin is a poem of contrasts. Discuss(by Carol Ann Duffy )...

Math, 6 months ago

solve the following 4 out of 7 equal parts...

Science, 11 months ago

Q. What happens to the path of a ray of light when it passes from i) Optically rarer to denser medium ii) denser to rarer medium brainliest question...

Physics, 11 months ago

Select One Option Correct from the following : In the Bohr’s model of the hydrogen atom, (A) the radius of the $n^{th}$ orbit is proportional to $n^{2}$ . (B) the total energy of the electron in the $n^{th}$ orbit is inversely proportional to n. (C) the angular momentum of the electron in an orbit is an integral mul- tiple of $h/\pi$ . (D) the magnitude of...

Computer Science, 1 year ago

true or fasle please help me...

English, 1 year ago

long ago there was an old man in a village. He was very interested in yoga. On a certain day he saw some yoga teacher conducting yoga classes in the field........,.........

Biology, 1 year ago

valves prevent the back flow of blood. then why do arteries dont require valves?