Query on a table runs more than 45mins(after stats) and same query runs 19secs(before stats - rebuild) - Not sure what the cause is.
- Analysed the explain the plan
- different explain plan used afterr stats gather.
Any idea what could be the cause with this kind of difference.
Will stats update cause the performance, only difference seen is in the explain plan.
Plz share the explain plan??
What is the difference you see in the explain plan ? Where it spends most time. All these needs to be analysed.