All Forums UDA
giri 24 posts Joined 11/05
16 Jun 2006
performance issue

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.

BBR2 96 posts Joined 12/04
19 Jun 2006

I don't think there is any performace benefit doing this as in both cases we are not exploiting indexing strategy.Multistatements are good as they will be sent to database as a block.insert into ... sel from table1;insert into ... sel from table2;is typical example I can think of.Lets see what others have to say.Vinay

You must sign in to leave a comment.