What is the most efficient way to join dba_data_files and dba_tab_partitions to select num_rows and bytes to display both with a single query? thanks. _________________________________________________________________ Enjoy 5 GB of free, password-protected online storage. http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008