PERFORMANCE ISSUES

Analytics
Enthusiast

PERFORMANCE ISSUES

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 ISSUES

The statements

SEL * FROM TABLENAME and SEL * FROM TABLENAME WHERE 1=1 have all rows scan access path. The performance difference is none.

If you consider the following scenario,

INS Target SEL * FROM Source;

and

INS Target SEL * FROM SOURCE WHERE 1=1 there is a big difference.