9i I know this was discussed in the past, although not necessarily DW/DSS/OLAP specific. I am looking for best practice to user in terms of takign stats in a DW. Any advice, pointers, link to paper of previoous discussion appreciated. Thanks -- .. David -- //www.freelists.org/webpage/oracle-l