> > Thanks Brinkman..
> > Is there any other way?
> >
> > Regards,
> > Siva

At 07:24 PM 9/02/2004 +1100, Alan McDonald wrote:

>If you really want to slow things down - you could pull that little blue
>cable out of the back of your server - it won't use any plans after that.

**Cute**, but there are valid reasons for not using an index. Luckily, Arno
got to the question first and supplied a good answer to a perfectly
reasonable question.

-- not all indexes are good indexes
-- not all good indexes are "good" in any query
-- an index that is "good" with one set of "data demographics" might slow
things down with another.

Careful designers are very conservative about indexing, especially around
an optimizer that is significantly cost-driven. One of the daffiest things
you can do with Firebird is to become a slave to your CASE tool and the
rule-driven metadata it spits out for you, or to that "Made in Redmond" SQL
rulebook.

/hb