Our system is going to production and I created table/index creation script with storage parameter.
According to our DBA in 9i we should not define storage parameter oracle will automaticaly take care.
Is this true ? we have heavy data laoding data warehouse.
What is your experience in 9i for performance gain should we define appropriate storage parameter for table and index creation ?
I am talking about initial and next parameters. I have gone through your article it does not say about it.
Shell we create tables/indexes with initial and next parameters in 9i for better performance ?