Alan,

This is not the support list, please go to www.mers.com, join the
Interbase Support List and then re-submitted you message to this list.

When you submit your message, could you include the plan that IB would
use for the query, if you did try and specify a plan.


Sean
-----Original Message-----
From: Alan Candido [mailto:acandido@...]
Sent: Wednesday, December 06, 2000 12:56 PM
To: IB-Architect@egroups.com
Subject: [IB-Architect] IB - PLAN clause in the SELECT

Gentlemen,

Sorry, but my english is bad.

In select

select TEMPO.DT_EVENTO as DT_EVENTO,A1.COD as CLIENTE,b1.COD as PRODUTO
,SUM
( D2.QUANT ) as QUANT,SUM ( D2.TOTAL ) as TOTAL
from D2 ,TEMPO,A1,B1
where TEMPO.DT_EVENTO = D2.EMISSAO
and A1.COD = D2.CLIENTE
and B1.COD = D2.COD
group by TEMPO.DT_EVENTO,A1.COD,B1.COD
PLAN SORT (JOIN (D2 INDEX (D2_03), B1 INDEX (RDB$PRIMARY2),TEMPO INDEX
(RDB$PRIMARY4),A1 INDEX (RDB$PRIMARY1)))


I placed " plan clause" but I get the error " Index D2_03 cannot be used
in
the specified plan ". The D2_03 index belongs the table that this being
specified (D2) and is composite of field D2.Emissao. The " plan "
presented
in the IBConsole is " PLAN SORT (JOIN (D2 NATURAL, B1 INDEX
(RDB$PRIMARY2),
tempo INDEX ", but I believe that to obtain itself to force I will have
performance profit. I have about 2,200,000 in the table D2, 15.000 in
B1
and 9.000 in A1.

I look for information on tunning for performance profit.

Some ideia or suggestion to gain performance.

Grateful

Alan Candido ><>





[Non-text portions of this message have been removed]


To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com