Sorry ... It was the DRIVING_SITE hint. Jon Knight -----Original Message----- From: Joe Cooper [mailto:aregularjoe8@xxxxxxxxx] Sent: Monday, January 31, 2005 1:07 PM To: jknight@xxxxxxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx Subject: RE: View vs. Synonym (across DBLink) That's great. But you didn't mention which solution worked (or, if you did, I lost it in the thread). Could you clue in the clueless (i.e. me!!), please!!?? Thanks, Joe Cooper Senior Oracle DBA Highline Data Austin, TX "Knight, Jon" <jknight@xxxxxxxxxxxxxx> wrote: Thanks all (including those that replied to me directly). Execution time dropped from 18:24 to 01:26, which is acceptable now. Thanks, Jon Knight Senior Database Analyst 2525 Horizon Lake Drive, Suite 120 Memphis, TN 38133 JKnight@xxxxxxxxxxxxxx 901.371.8000 - Phone 800.238.7675 - Phone 901.380.8336 - Fax www.FirstData.com First Data's merger with Concord creates "One Company" with enhanced choice, voice and innovation for all customers. -----Original Message----- _____ Do you Yahoo!? Yahoo! Search presents - Jib <http://us.rd.yahoo.com/evt=30648/*http://movies.yahoo.com/movies/feature/ji bjabinaugural.html> Jab's 'Second Term' -- //www.freelists.org/webpage/oracle-l