i will need every day reload big table. This table has ~40 columns and will need ~10 indices.
Which way is better.
1) Create table once with indices. Before load do truncate and then load.
2) First load data and then create indices. Before load do drop table.
Or it doesn't matter on performance?
View Complete Post