Re: pro C versus PL/SQL
From: Lolita <lolitagroux_at_hotmail.com>
Date: 31 Mar 2003 04:04:41 -0800
Message-ID: <8027ad1.0303310404.73234f47_at_posting.google.com>
Date: 31 Mar 2003 04:04:41 -0800
Message-ID: <8027ad1.0303310404.73234f47_at_posting.google.com>
Thanks a lot.
The
SELECT *
> FROM (
> SELECT ...
> CASE
> WHEN <dynamic condition> THEN 1
> WHEN <dynamic condition> THEN 2
> ...
> ELSE -1
> END AS RULE_NUMBER
> FROM (<that original select you have>)
> )
> WHERE RULE_NUMBER != -1
>
idea is really great, this decrease significantly the execution time.
Thanks again
Lolita
Received on Mon Mar 31 2003 - 14:04:41 CEST