Why join them at all? Just look at dba_segments and tab_tab_partitions for segment_type of "TABLE PARTITION" , joined between partition_name. I'm not sure where dba_data_files comes in if you want the size of the partition segments. On Fri, Jun 6, 2008 at 10:37 AM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > 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. Get Windows Live > SkyDrive.<http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008> > -- Bradd Piontek Twitter: http://www.twitter.com/piontekdd Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd Last.fm: http://www.last.fm/user/piontekdd/