Data type conversion and TABLE ACCESS BY GLOBAL INDEX ROWID
Hi,
Oracle version :11.2.0.2 OS- HP UX
One of my queries have high elapsed time and is causing DB file sequential read.The plan show a data type converion.
The datatype of that column in table is NVARCHAR2(100) where in the v$sql_bind_capture shows it as NVARCHAR2(32). My front end is Java based.Is there any way to pass NVARCHAR2(100) fron front end for bind variable?
Also PFB the plan.Is TABLE ACCESS BY GLOBAL INDEX ROWID good for performance?
Oracle version :11.2.0.2 OS- HP UX
One of my queries have high elapsed time and is causing DB file sequential read.The plan show a data type converion.
The datatype of that column in table is NVARCHAR2(100) where in the v$sql_bind_capture shows it as NVARCHAR2(32). My front end is Java based.Is there any way to pass NVARCHAR2(100) fron front end for bind variable?
Also PFB the plan.Is TABLE ACCESS BY GLOBAL INDEX ROWID good for performance?
----------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | ----------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT
0