Latest Activity

code

One of our View is running longer.

Hi, One of our query is running longer. Scenario-1: We have created one view to get some columns( using case statements) and used 4 to 5 sub queries and joined them individually with main table. Scenario-2: We have modified the Scenario-1 query like m...

longrunningquerry Base View configuration

code

Stopping a long running querry

Hi Team I am trying to kill a few long running queri's from query monitor by selecting row and click on stop querry button. but it seems it is not having any effect. Am i doing it right way to stop a long running querry ?

stopping longrunningquerry querrymonitor