Re: Select count(*) in Oracle and MySQL

Mladen Gogala wrote:
> SQL> select /*+ index_ffs(no,PK_NI_OCCURRENCE_ID) */
> 285395625
> SQL> select count(*) from ni_occurrence;
> 285396154
>

I do hope the table you used in this example is heavily used, and that that usage explains for the increase in count.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...