12-24-2008, 03:51 PM
|
#4 (permalink)
|
|
Wizard
Join Date: Sep 2007
Posts: 1,299
Thanks: 17
|
Quote:
Originally Posted by geo353
i think they would both use about the same seeing as whichever you use they both just count the nunber of rows.
|
But the wildcard key gives SQL more to do, SELECT * FROM table is almost always slower than SELECT id,username,othercolumn1,ect FROM table |
|
|
|