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

History, 6 months ago

Explain the German rearmament and withdrawal from League of Nations...

Science, 6 months ago

what is a molecules ...

Math, 6 months ago

Find domain, co-domain and range for f:{-2, – 1, 0, 1} → Z, f(x) = 4x^2 – x + 3...

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?