Thanks Joe, for your input. My system is a DSS database and now the size of the biggest table is 150G. The sort_area_size is 20M at present according to some of the queries.

Can you suggest some of the common things to be taken care of for a table of this size, to acheive the best performance for queries.

It would be great if you could write the site of Steve Adams.


Thanks and Regards

gtm