Thank You Gail and Jacob for you reply's

Gail

I tried running query multiple times every time massive I/O on scenario 1

Jacob

I looked at...