Yes, I've tried using "SET STATISTICS" and even drop and recreate the
index didn't work.

On Nov 19, 2007 1:34 PM, Ivan Prenosil <Ivan.Prenosil@...> wrote:
> > I've changed a field collate, but it only "worked" after a backup and restore.
> > So is it really required to backup and restore the database when a
> > collate is changed?
>
> Have you rebuild affected indexes ?
>
> Ivan P.
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>



--
Erick Sasse