Re: "select *" MUCH quicker than "select <field> from...": explanation ?

spendius_at_muchomail.com (Spendius) wrote in message news:<aba30b75.0407070517.317db00b_at_posting.google.com>...
> Sybrand Bakker <sybrandb_at_hccnet.nl> wrote:
> > - compare the execution paths and/or ran EXPLAIN PLAN?
> > - traced the session ?
>
> Below:
> o plan when selecting only one field (which is null actually
> o " " " all fields

select count(*) and select count(nullable field) are not same queries, you can not compare them Received on Wed Jul 07 2004 - 19:53:19 CDT