Hi,
I currently am using a set of staging tables to load data into for pre-processing. I am looking for some ideas to increase the performance of this data processing.
Obviously the whole area of indexing on the staging tables and the structure of the accessing Sql code is something I am looking at.
Q1. Would table type make any difference to performance i.e. permanent vrs temporary tables ?
Q2. Would External Tables be an alternative and is there performance anything better than Iwould be currently using ?
Q3. Are there any other suggestions ?
any advice gratefully received
thanks,
Jim