Hello:

I meant ownername as both the index and select. As I said, takes
forever.

--- In IBObjects@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@...> wrote:

>
> Hi John!
>
> Converting from BDE/Paradox to IBO/Firebird (Firebird is the
> open-sourced daughter of InterBase, many of us think it is

superior to

> it's mother) is a big task. It is converting from BDE/Firebird to
> IBO/Firebird that is what www.ibobjects.com mentions a a switch

that can

> be done in seconds.
>
> > The SQL for the query is SELECT * FROM XXXXXXXX WHERE
> > PERSONSNAME = RANKLEY ORDER ON OWNERNAME (Ownwername is a

defined

> > index).
>
> This query doesn't benefit much from an index on Ownername, what

you

> want is an index on Personsname. Since I assume that field to be

far

> from unique, I think you should consider creating an index on
> (PersonsName, PrimaryKeyField) - this makes updating and deleting

faster.

>
> Welcome to the world of client/server database programming!
> Set
>