"Associate Statistics With" Option does not Differentiate Between Function and Package Object
(Doc ID 2490985.1)
Last updated on APRIL 09, 2020
Applies to:Oracle Database - Standard Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- "ASSOCIATE STATISTICS WITH" option does not differentiate between package and function objects.
- For example if you use it for a package object with function option, it will not shows any error:
ASSOCIATE STATISTICS WITH FUNCTIONS testpkg DEFAULT SELECTIVITY 10, DEFAULT COST (100000,10000,0);
( Note : testpkg is a package here and not a function)
- But above statement will not have any impact and you can verify it from plan generated
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document