最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

oracle database - How to have DBMS_STATS.GATHER_TABLE_STATS() Ignore a Virtual Column? - Stack Overflow

programmeradmin4浏览0评论

Is there a way to instruct dmbs_stats.gather_table_stats() to ignore a particular column?

Context: I have a table that has a virtual column that performs a standard_hash() of the concatenation of several columns. When this table is analyzed, that virtual column gets calculated for every row in the table. The presence of this virtual column, therefore, causes the time required to analyze the table to increase.

Most of the time I would like the virtual column to be analyzed, but sometimes I don't need the virtual column analyzed.

Generally, when the table is analyzed, I would want that virtual column to be analyzed. However, in our Data Warehouse batch load process we analyze the table several times during the load process for the benefit of subsequent downstream batch load processes. I do not always need the virtual column analyzed. Hence, I am inquiring if there is a way for me to control whether or not the virtual column is analyzed when its table is analyzed.

发布评论

评论列表(0)

  1. 暂无评论