(Neil Johnson) Past experience has always led me to believe that a METHOD_OPT value of gFOR ALL COLUMNS SIZE REPEATh would default to gSIZE 1 on columns without statistics. I have never explicitly tested this default however so this is the quick test I did to put my mind at rest.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help