Gather Statistics on Empty tables will get the execution plan or not?
960755Sep 7 2012 — edited Sep 7 2012Hi,
I have a tables of size 25GB (3 crores plus rows) and the tables are partitioned.
Now i have an issue
For example there is a table T1 with 25GB size (3 crores rows) and partitioned when i try generating statistics for a T1 table with below command it takes lots of time and i dont know what is the progress.
begin
dbms_stats.gather_table_stats(ownname=> 'CBPRDATA', tabname=> 'T1', partname=> NULL);
end;
Now my plan is ...
1) truncate the table ( I have flat file to load the data using sqlloader)
2) gather states using above script
3) then load the data using sql loader
4) check if the SQL query is going through partition indexes in execution plan
Question: Will ganerating statistics on an empty table with partitions will create the execution plan for sql queries or not ?
Quertion: Is there any best method to gather states for such tables with 3 crores of rows?