Ram�n Jim�nez wrote:
Joy,
If memory serves me right each property has a SELECTIVITY parameter which
you can read.
Cach� 5.x introduced the %GetParameter() method to fetch the value of a
class parameter. Alas, this doesn't work with _property_ parameters. You'd
have to do something like:
Set propDef = ##class(%Library.PropertyDefinition).%OpenId(
"ClassName||Propname")
Set propSel = propDef.Parameters.GetAt( "SELECTIVITY")
Set propDef = ""
HTH,
Ram�n
Thanks for the information. Unfortionately, that will only tell you the
selectivity if it was set in the class by the developer. What I am
trying to get is the value for selectivity that is set when a user
executes $system.SQL.TuneTable(). Cache appears to store this value
somewhere else. I would even be happy with a way to see what the value
of selectivity would be if you ran $system.SQL.TuneTable().
Joy
