SQL

Database
Enthusiast

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 will be difference
2 REPLIES
Enthusiast

Re: SQL

please help with your expertise..
Senior Apprentice

Re: SQL

Is the first or the second ins/sel faster?
How do you measure it?

Unless one ins/sel is into an empty table and the other into a populated table there will be no difference.

Dieter