Martijn:

Thank you anyway. Just in case I deleted the index I had and
recreated again. The queries results were the same: about 20 seconds
for 2 users and 30 seconds for 3 users.
I will continue to search a solution.
Regards,

Wagner Bazarin
Mac-Penn
Sao Paulo
Brazil

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> > Can you run these statements and try the query again?
> >
> >
> > CREATE ASC INDEX I_PALAVRA_1 ON PALAVRA (ORIGINAL);
> >
> > CREATE ASC INDEX I_PALAVRA_2 ON PALAVRA (ORDENADA);
>
> Bah, ignore my comments... didn't read your question too well.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com