[thelist] Select *

Scott Dexter sgd@ti3.com
Thu Oct 12 12:10:27 2000
 
> Is there a drawback to using 'select *' if you _do_ need all 
> the columns, 
> as opposed to explicitely listing all of them?

yah, you incur a table scan instead of using any index to find the records.
(I feels like I says this already, eh)

Oh-- table scan bad, index good =)
sgd