Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

bunch of oracle questions

Hi Guys,

I have some oracle questions. What does generating statistics for a table or index

actually do? And what is the difference between estimate statistics and compute

statistics 10% or any other percentage?

How does creating new statistics improve performance?Also, what is brconnect

used for? i saw it being used for statistics as well as some other things.

what are the various uses for it?

And coming to a different topic, can someone tell me the difference between

the rollback segments concept of oracle 8 and the undo tablespace concepts

of oracle 9.

Thanks in advance.

Cyrus

Not what you were looking for? View more on this topic or Ask a question