Have you tried your results by turning the rules off?? Set rules off
Your should use the unique key for the INVNO column. It will be much faster than the rule. Dan Goldberg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Sent: Thursday, February 11, 2010 6:19 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Speed issues sure, No Triggers, No functions, 3 indexes Custno, Invno, IDTrans (all unique numbers) 1 rule: Ardetail.INVNO IS NOT NULL AND NOT Ardetail.INVNO IN ( SELECT INVNO FROM Ardetail #T1 WHERE #T1.INVNO = Ardetail.INVNO ) Table: Ardetail No Lock(s) No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 CUSTNO Type : TEXT 6 Index : SINGLE-COLUMN 2 INVNO Type : TEXT 12 Index : SINGLE-COLUMN 3 SDATE Type : DATE 4 IDTRANS Type : TEXT 20 Index : SINGLE-COLUMN 5 INVAMT Type : CURRENCY Default: 0 6 INVCUR Type : CURRENCY Default: 0 7 PAYCUR Type : CURRENCY Default: 0 8 PAYAMT Type : CURRENCY Default: 0 9 CHKNO Type : TEXT 20 10 CHKDATE Type : DATE 11 CREDIT Type : CURRENCY Default: 0 12 SVCHARGE Type : CURRENCY Default: 0 13 CURBAL Type : CURRENCY Default: 0 14 AFTER30 Type : CURRENCY Default: 0 15 AFTER60 Type : CURRENCY Default: 0 16 AFTER90 Type : CURRENCY Default: 0 17 OVER120 Type : CURRENCY Default: 0 18 SCDROPPED Type : CURRENCY Default: 0 19 TOTSVCH Type : CURRENCY Default: 0 20 INVBAL Type : CURRENCY Default: 0 21 MONTHNO Type : INTEGER 22 SC_OK Type : TEXT 1 Default: Y 23 Posted Type : TEXT 1 24 SYEAR Type : INTEGER 25 SPERIOD Type : INTEGER 26 batchno Type : INTEGER Current number of rows: 100476 At 09:07 AM 2/11/2010, you wrote: >Please post the structure of your table, including a list of indexes, >rules, triggers, and constraints that apply. >-- >Larry
