Hi,
Instead of sending prepared statements, we've sent a plain query from jdbc
there was no difference. Timings for prepared statement and plain query are
the same.
V. Oguz TOKMAK
> "Or are you sending the JDBC as a prepared statement with parameters?"
> That is correct, I execute the query with the parameters replaced on iSQL+
> however they are sent as a prepared statement from jdbc.
>
> I'm sending a sample query, when I execute it on iSQL+ by replacing the
> parameters I got immediate results, but when I execute it as a prepared
> statement I got the results about in 7-8 secs.
> As seen on execution plan, the query requires two full table scans, both
> tables have about 1000 entries, I know that indexing will further improve
> the execution but I cannot understand the difference between iSQL+ and
> JDBC. However I got the idea, I'll keep experimenting using the
> information you gave me and post the results.
> Thanks.
>
> SELECT /*+ USE_NL(WFAPPLICATIONWPOPS,CULTEXT) INDEX_ASC(WFAPPLICATIONWPOPS
> I_APPWPOPS_02)*/ DISTINCT
> WFAPPLICATIONWPOPS.LOGICALREF AS LogicalRef, WFAPPLICATIONWPOPS.OPID AS
> OpId, WFAPPLICATIONWPOPS.CODE AS Code, WFAPPLICATIONWPOPS.OPCATEGORY AS
> OpCategory, WFAPPLICATIONWPOPS.OPTYPE AS OpType,
> WFAPPLICATIONWPOPS.OPPERFORMER AS OpPerformer,
> WFAPPLICATIONWPOPS.ISINTERNAL AS IsInternal,
> WFAPPLICATIONWPOPS.ISINTERACTIVE AS IsInteractive,
> WFAPPLICATIONWPOPS.WFSPECIFIC AS WFSpecific, WFAPPLICATIONWPOPS.TE_WPIID,
> CULTEXT.OWNERCODE AS OwnerCode, CULTEXT.OWNERTYPE AS OwnerType,
> CULTEXT.OWNERNAME AS OwnerName, CULTEXT.OWNERDESC AS OwnerDesc,
> CULTEXT.OWNERTYPEDESC AS OwnerTypeDesc, CULTEXT.CULTURE AS Culture
> FROM
> W_APPWPOPS WFAPPLICATIONWPOPS LEFT OUTER JOIN W_APPWPOPCULTEXTS CULTEXT ON
> ((CULTEXT.OWNERCODE = WFAPPLICATIONWPOPS.CODE) AND (CULTEXT.OWNERTYPE =
> 2))
> WHERE
> ((CULTEXT.CULTURE = ?) AND (WFAPPLICATIONWPOPS.ISINTERNAL = ?) AND
> (WFAPPLICATIONWPOPS.WFSPECIFIC = ?))
> ORDER BY
> CULTEXT.OWNERNAME ASC, WFAPPLICATIONWPOPS.CODE ASC
>
> [06.03.2006 22:38:44:003 EET] 63be63be SystemOut O Parameters :
> [06.03.2006 22:38:44:003 EET] 63be63be SystemOut O P_CULTURE = 'TRTR'
> ==> CULTURE, NVARCHAR2, 5
> [06.03.2006 22:38:44:003 EET] 63be63be SystemOut O P_INTERNAL = 0 ==>
> ISINTERNAL, NUMBER, 10
> [06.03.2006 22:38:44:003 EET] 63be63be SystemOut O P_WFSPECIFIC = 0
> ==> WFSPECIFIC, NUMBER, 5
>
> V. Oguz TOKMAK
>
Received on Tue Mar 07 2006 - 03:06:17 CST
