search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.13k stars 281 forks source link

I am facing below warning once the execution is stopped for sp_whoisactive.. Should I be worried for the data due to this? #115

Closed sumabris closed 4 months ago

sumabris commented 6 months ago

Hi I am facing below warning once the execution is stopped for sp_whoisactive.. Should I be worried for the data due to this?

Warning: The join order has been enforced because a local join hint is used. Warning: Null value is eliminated by an aggregate or other SET operation

Thanks, Suma B R

M-Frenzel commented 6 months ago

Hi @sumabris

those warnings provide you with hints that you should be aware of in case the data is wrong or the query takes a long time.

Warning: The join order has been enforced because a local join hint is used. is printed because some JOINs are hinted, for example INNER LOOP JOIN instead of INNER JOIN. Normally you do not need those hints, sometimes they are in fact necessary to provide a fast or stable execution.

Warning: Null value is eliminated by an aggregate or other SET operation is printed usually because of the usage of aggregation functions such as SUM or AVGon columns that contain NULL values. NULL are not processed.

If you want to get rid of the last warning, you can add SET ANSI_WARNINGS OFF before executing the procedure.

I see no reason to be worried.