Set NewExtentSize = ##Class(%SQL.Manager.Catalog).GetCalcTableExtentSize($P(sqlclass,".",1), $P(sqlclass,".",2))
//Execute %Analyze but skip it if indices take too long
These two areas of code can cause the report to take a long time. It would be nice if there was an additional flag to include/exclude these parts. Sometimes it may be worth it to wait the extra time to get these parts of the report when we know we will care about them. Currently we will need to run some commands manually, which does gives us the information. However, this information will likely be lost when looking back at the report in the future
Set NewExtentSize = ##Class(%SQL.Manager.Catalog).GetCalcTableExtentSize($P(sqlclass,".",1), $P(sqlclass,".",2))
//Execute %Analyze but skip it if indices take too long
These two areas of code can cause the report to take a long time. It would be nice if there was an additional flag to include/exclude these parts. Sometimes it may be worth it to wait the extra time to get these parts of the report when we know we will care about them. Currently we will need to run some commands manually, which does gives us the information. However, this information will likely be lost when looking back at the report in the future