A quick example of the difference in sqlnet bytes returned
My top speed dialup capability proof
An introduction to DBMS_RANDOM
A script using DBMS_RANDOM to generate a few million rows of test data
Create and generate random invoice data for testing.
Some instructions on using 3 of the oracle SQL analytics functions.
I tested if when you drop and recreate an index if the statistics are gathered at create. I assumed they were not. I was correct for v8 but was wrong on v9 and v10. You learn something every day.
The test scripts
for V9 and V10
Playing with indexing dates