While tuning a mammoth query, I noticed that one of the tables in the from clause is actually a view. It's defined as "select * from table_name@dblink". Is there any reason to believe I could improve performance by dropping the view and using a synonym instead? Thanks, Jon Knight -- //www.freelists.org/webpage/oracle-l