> Well, yes, maybe this isn't the solution in your case. In theory,

that

> could at worst mean more than a million if-elses But I doubt that

all

> 20 parametres are used equally much by themselves and that all of

them

> would benefit from using an index. Maybe you can cut down the

number

> of likely alternatives to just a few making this a feasible

solution,

> and maybe not. If feasible, all unlikely alternatives could go

into a

> separate statement that never used any index (like your procedures
> currently do).
>
> Set

For now i'm wondering if to use this or to build the query
dynaically in the procedure with the
FOR EXECUTE STATEMENT :STMT INTO :PERSONID DO
SUSPEND;