does it require frequent statistics update or refactor the query isself avoid Estimate/Actual row descrepency and 3 table scans?

George Zhou 2017-03-16 18:41:53

does it require frequent statistics update or refactor the query isself avoid Estimate/Actual row descrepency and 3 table scans?