SQL

UDA

SQL

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.

can anyone illustrate what is the difference