Computer Science, asked by purushotam3959, 1 year 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

Computer Science, 6 months ago

make a circuit diagram of idempotent law...

Math, 6 months ago

if a^4+b^4=a^2+b^2 proove a^6+b^6=0...

Math, 6 months ago

-3+7 -9 please fast answer of this question ...

Science, 1 year 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, 1 year 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?