Good Afternoon,
I'm having a problem with a certain query.
The query used to go twice in the same huge table. To solve that problem I've used a decode on certain columns, but surprisingly
the query performance became worst. I was forced to use decode on 25 columns.
My question is:
Is it possible that a lots of decodes degradates the query performance?