MySQL Forums
Forum List  »  Performance

Re: Is my hardware slow or is it MySQL performance?
Posted by: KimSeong Loh
Date: October 05, 2005 07:24PM

With Myisam table, select count(*) from cpath should return in an instant without scanning the full table.
However, select count(*) from cpath where id > 0, will cause an index scan on the Primary key `id`.
Still not a full table scan.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Is my hardware slow or is it MySQL performance?
1370
October 05, 2005 07:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.