"Associate Statistics With" Option does not Differentiate Between Function and Package Object (Doc ID 2490985.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.2 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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.