On 10 Mar 2016, at 9:54am, Jim Wang <2004wqg2008 at 163.com> wrote: > sql one : select * from table_name where id = **; > sql two : select count() from table_name where id = **; > > > I test the two sql statement. It almost the same speed.
Another possibility to test for speed is select 1 from table_name where id = **; For a single command I would expect all these to take the same time. For a look of ten thousand you might expect to see a difference. However, unless your application is taking so long to get the result I support your idea that it doesn't matter which you use. Simon.
