Hi there I was just wondering what would be the difference between these 2 METHOD_OPT parameter settings:
FOR COLUMNS SIZE 5 some_column
FOR COLUMNS some_column SIZE 5
both will create a histogram with 5 buckets for the column 'some_column' right?
The official Oracle reference states that METHOD_OPT should have this form:
FOR COLUMNS [size clause] column|attribute [size_clause] [,column|attribute [size_clause]...]
but this doesn't really help my case.
I've seen sources which use both versions so not sure if there is any difference.
I was told that both of these are the exact same, but then what about these 2:
FOR COLUMNS SIZE 5 some_column SIZE 6 some_column2
FOR COLUMNS some_column SIZE 5 some_column2 SIZE 6