Can advise how can I get the chain cnt without risking my existing statistis?analyze table <TABLE_NAME> list chained rows into <CHAINED_ROWS_TABLE>;
Chewy wrote:It would be useful to know why you want this information, and whether you are aware of the three ways in which chained rows may get reported (and it varies with versions of Oracle). You have row migration - which is an update anomaly that can usually be addressed, "proper" row chaining when the content a row is too long to fit into a single block, and "intra-block" row chaining when the the number of columns in a row exceeds 255 (and a column past 255 has been populated).
Can advise how can I get the chain cnt without risking my existing statistis?
And also will analyze table <tab_name> estimate statistics; overwrite my existing histograms?