All Forums Analytics
giri 24 posts Joined 11/05
15 Jun 2006
PERFORMANCE ISSUES

SELECT * FROM TABLENAME; ANDSELECT * FROM TABLENAME WHERE 1=1;WILL THERE BE ANY PERFORMANCE DIFFERENCE;AND ALSOWHAT WILL BE THE PERFORMANCE ISSUE WITH MULTI STATEMENT REQUEST?WITH AN EXAMPLE PLEASE.

Phani 15 posts Joined 07/04
19 Jun 2006

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.

You must sign in to leave a comment.