Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle linux patching

User_DTHN5Sep 28 2021

I have an old spacewalk v2.2 . I want to patch oracle linux 6 and 7 servers. What is the best path.

Comments

Hemant K Chitale
A CREATE INDEX automatically computes statistics on the Index (if you want to update Table and Column statistics, you still need to call DBMS_STATS.GATHER_TABLE_STATS --- e.g. if it is a Function Based Index, you need to update Table statistics because the FBI creates an additonal "virtual" column in the table).


Hemant K Chitale
sb92075
Petri BR wrote:
Good night, I tryed it before and got no help.
So I'll try it again, because I didn't find it yet.

I have to create some indexes in a production database.

I have a doubt.
Do I need to Compute Statistics after creating indexes?
after CREATE INDEX what are the values for the index statistics?
Or when I create they automatically are computed?
Just look at the statistics values after issuing CREATE INDEX & answer the question yourself!
1 - 2

Post Details

Added on Sep 28 2021
3 comments
548 views