performance impact when setting limit

[Avi]

is there any difference in performance between this two queries 

1. SELECT COUNT(*) FROM big_table ;

2. SELECT COUNT(*) FROM big_table LIMIT Int.MAX_VALUE;




[Andrew Tolbert]

Hello,

Can you explain why you would use LIMIT Int.MAX_VALUE in the first place?  As far as performance goes, I'm not certain of what to expect, but I think it would be nearly the same, maybe some extra time (which may be negligible) parsing the query since it has extra criteria.

Thanks,

Andy