Search SSWUG.ORG:



DATABASES

Plan HASH_VALUE remains the same for the same Execution Plan, even if ROWS and COST change This is an off-site link.  Please review our Terms of Service for additional information.


(Hemant K Chitale) Here is a simple demo that shows that the Plan Hash_Value does not consider the ROWS and COST but only the Execution Plan. Thus, even with more rows added into a table, if the Execution Plan remains the same for a query, it is independent of the number of ROWS and the COST changing.

Read this article..







comments powered by Disqus