bunch of oracle questions
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.