Jason

I have the following index defined on the table

Create INDEX transtable1 ON transtable ( CUSTOMER, TRANS_ID,
INV_NUMBER )

And it is still slow does it need to be specified as descending?
(I am currently under the impression that descending is the default)

Thanks Peter

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> This is due to horizontal dataset refinement. If you create an index
> (descending) which will support this action then your performance
problem
> will be resolved.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "pmagor2001" <pmagor@h...>
> To: <IBObjects@y...>
> Sent: Thursday, January 17, 2002 12:30 AM
> Subject: [IBO] Understanding the IB_MonitorDialog Output
>
>
> > Hi all
> >
> > I am using the IB_MonitorDialog to help with the development of a
> > program and I have question about its output.
> >
> > The following is in the log
> >
> > SELECT ALL transtable.*
> > FROM transtable
> > WHERE CUSTOMER < ? /* PRM_0 */ /* OLNK_CUSTOMER */
> > ORDER BY CUSTOMER DESC
> > , TRANS_ID DESC
> > , INV_NUMBER DESC
> >
> > Now I recognise the field names (CUSTOMER, TRANS_ID and
INV_NUMBER)
> > and the table name (transtable) but what I don't recognise is the
> > condition and the PRM_0 and OLNK_CUSTOMER. Can any one help me to
> > identify why this query is generated? It's currently slowing down
the
> > program as it can take over a minute to run.
> >
> > Thanks in advance
> > Peter Magor