2 excellent Proven Practices documents were published today, describing how to speed up publising (cognos.com login is required):
– using oracle
– using ms sql server
Same old “If you are loading data, drop indexes” roams ;)