performance issue

UDA
Enthusiast

performance issue

SELECT * FROM TABLENAME; AND

SELECT * FROM TABLENAME WHERE 1=1;

WILL THERE BE ANY PERFORMANCE DIFFERENCE;

AND ALSO

WHAT WILL BE THE PERFORMANCE ISSUE WITH MULTI STATEMENT REQUEST?

WITH AN EXAMPLE PLEASE.
1 REPLY
Enthusiast

Re: performance issue

I don't think there is any performace benefit doing this as in both cases we are not exploiting indexing strategy.

Multistatements are good as they will be sent to database as a block.
insert into ... sel from table1;insert into ... sel from table2;
is typical example I can think of.

Lets see what others have to say.

Vinay