PERFORMANCE ISSUE

Tools & Utilities
Enthusiast

PERFORMANCE ISSUE

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.