Re: Question: Tables accross schemas...

sergey_s_at_my-deja.com wrote:
>
> Are there any performance issues to consider when accessing
> tables outside the current schema?

Hmmm...can't think of any -- meaning that I can't think of any perf. penalty associated explicitly with a query accessing a table owned by some other schema in the *same* database. Of course , the "foreign" table may be poorly designed or the optimizer may make poor decisions, but it seems to me all that would be true for the same query launched by the object owner.

FWIW...
--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730