Quote:
Originally posted by htanga
Do the stats on SYS schema have impact on the behavior of CBO ?
Because the stats are gathered every night by the dbms_utility.analyze_database procedure on our databases !
So, could the stats on SYS schema bother queries on tables in others schemas ?
I've seen it both ways. Until recently, I always have observed queries against the Data Dictionary are faster when the SYS tables were not analyzed. However, I recently saw a white paper (although I can't put my browser on it) stating that the SYS schema can and SHOULD be analyzed with late 8i and 9i databases. I ran some quick tests on a 9.2 database and didn't see a difference either way. My opinion is still mixed...