speed of dba_tables vs all_tables

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 Received on Sun Nov 19 2000 - 07:25:25 CST