|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/28/2006 5:14:00 AM
Posts: 26,
Visits: 1
|
|
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.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 5/2/2008 2:28:55 AM
Posts: 15,
Visits: 2
|
|
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.
|
|
|
|