Re: speed of dba_tables vs all_tables

This is normal. Selecting from DBA_TABLES will give you information about every table in the system. This information is gleaned from SYS.OBJ$ if memory serves me right. Select from ALL_TABLES will only give you information about those tables you own and those tables you have rights to. So aside from just giving you information on every table, the system has to determine which of those tables you own or have access to. This takes additional time. So the query should take longer.

HTH,
Brian

Terry Diederich wrote:
>
> Hello,
>
> It is taking longer to return a result set from all_tables compared to
> dba_tables.
>
> This query gives me a result set (using sqlplus) in just a second or two:
>
> select * from dba_tables
>
> This query gives me a result set (again using sqlplus with the same
> username/password/server as before) in 15 to 20 seconds.
>
> select * from all_tables
>
> Is this normal? Is something not set up correctly?
>
> Thanks
> Terry Diederich
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================