[thelist] Select *

Scott Dexter sgd at ti3.com
Thu Oct 12 12:10:27 CDT 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





More information about the thelist mailing list