![]() ![]() ![]() The stattab parameter specifies the name of a table in which to hold statistics, and it is assumed that it resides in the same schema as the object for which statistics are collected (unless the statown parameter is specified). Therefore, you can maintain and experiment with sets of statistics. These parameters allow you to store statistics in your own tables (outside of the dictionary), which does not affect the optimizer. Most of the DBMS_STATS procedures include the three parameters statown, stattab, and statid. The DBMS_STATS subprograms perform the following general operations:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |