Are your indexes the same?
-Adam
----- Original Message -----
From: Whittingham, P <[EMAIL PROTECTED]>
Date: Fri, 20 Aug 2004 08:32:39 -0400
Subject: Oracle 8i dblink question
To: CF-Talk <[EMAIL PROTECTED]>
Hi All,
I am doing a dblink into secondary Oracle 8i database, it seems very
slow in a cfquery (see below). Is there a faster way ??
TIA,
Patrick Whittingham
United Space Alliance
<http://www.houseoffusion.com/banners/view.cfm?bannerid=40> <cfquery
name='test' datasource='test_db' blockfactor='100' >
select a,b,c,d,e
from <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
</cfquery>________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
