Re: [cx-oracle-users] Strange problem with query execution...

[Christian K. <ckl...@no...>]

Hi Thierry,

did you find a solution for that problem. It seems run in the same issues?

Thanks in advance
Christian

Thierry Florac schrieb:
> Le Thu, 05 Apr 2012 05:39:40 -0600,
>    Doug Henderson<djh...@te...>  a écrit:
>
>> Look for implicit type conversions in the where clause. If columns are
>> converted to match the parameter type, then an index on the column
>> will not be used. You may need to include explicit type conversion
>> around the parameters to prevent implicit conversion of indexed
>> columns. This is a subtle problem that can be very hard to detect,
>> but cause horrible query performance.
>>
>> For example, a clause like "numeric_column = :param1" may need to be
>> coded as "numeric_column = to_number(:param1)".
>
> Thanks for the hint !
> But I checked all database columns and query parameters and I only use
> strings; that's a point where SQLAlchemy prevents you from using bad
> query parameters types...
>
> Regards,
> Thierry