Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sort + external procedure tuning
> Hello,
> I test a query on db2 udb v7.2 EE and Oracle8i EE. On db2 it took me
> less than 30s. On Orale server it took me 10m.
> My query is like:
> SELECT id1, function_name(col2, 'Str1', col3, 'Str2')
> FROM MyTable
> Order by 2 desc;
>
> We use C/C++ external procedure. My table size is about 500M, 1M rows.
Seems that 10 Minutes is quite fair for such a query. I'm pretty sure, there's no parameter tuning to solve this.
TUNE YOUR SQL!!! Stephan Received on Thu Dec 12 2002 - 05:53:30 CST