SQL taking more time when selecting column which has length of Varchar2(4000) [message #354288] |
Fri, 17 October 2008 06:34  |
etl_prasad
Messages: 44 Registered: June 2005 Location: Scotland
|
Member |
|
|
Hi All,
we are facing strange problem while selecting data from table.
when we run select statement with out one particular column which has length of Varchar2(4000) query getting completed in just second..
and whenever we inclucde those columns ( we have only two and those just using in select clause) same query taking more than 15 seconds.
can anyone give ideas on the same..
Thanking in advance.
|
|
|
|
|
|