Toad World® Forums

SQL optimizer


#1

Interesting message from optimizer.


Butter

int_1.jpeg
int_1.jpeg


#2

Hi Marcin,

I’m not an expert in this area, however it seems to me that you are trying
to optimize a set of SQLs, I mean not only one. But SQL Optimizer doesn’t
support such things.

Anyway, can you please send me your SQL you are trying to optimize. I will have
closer look. Thanks.

regards,

Alexander Maximov
int_1.jpeg


#3

Hi Marcin,
I’m not an expert in this area, however it seems to me that you are trying to
optimize a set of SQLs, I mean not only one. But SQL Optimizer doesn’t support
such things.

Anyway, can you please send me your SQL you are trying to optimize. I will have
closer look. Thanks.
[…]

You are right. I’ve already discovered this optimizer feature.
Only this message about lack of variable declaration mislead me.


Butter