dear arno,

before to read your post i do an update of my table (ie: rebuild it) and from yesterday it's still working :(
i soon as it finish i will try your idea

stephane

--- In firebird-support@yahoogroups.com, "Arno Brinkman" <fbsupport@...> wrote:
>
> Hi,
>
> > but now i m facing another problem because i need to do :
> >
> > select first 10 skip 0 * from BIGTABLE where
> > (FieldA = xxx OR FieldA = www) and
> > fieldB = yyy
> > order by FieldA,
> > FieldB
> > PLAN (BIGTABLE ORDER fieldAFieldB)
> >
> > result given in 1000 ms...
> > not work very effeciently :(
>
> Out of curiousity, what result gives this query:
>
> select
> first 10 skip 0 *
> from
> BIGTABLE
> where
> (FieldA = xxx and fieldB = yyy) OR
> (FieldA = www and fieldB = yyy)
> order by
> FieldA, FieldB
>
> Regards,
> Arno Brinkman
> ABVisie
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> General database development support:
> http://www.databasedevelopmentforum.com
>
> Firebird open source database (based on IB-OE) with many SQL-99 features :
> http://www.firebirdsql.org
> http://www.firebirdsql.info
> http://www.fingerbird.de/
> http://www.comunidade-firebird.org/
>
> Support list for Firebird and Interbase users :
> firebird-support@yahoogroups.com
>
> Nederlandse firebird nieuwsgroep :
> news://newsgroups.firebirdsql.info
>