Thx, this working fine, anyway some indexing problems remain (other
indices are not used), but it solved problem for now. :)
Svein Erling Tysvær wrote:

>How did you do it? Doing
>
>select * from table1 full join table2 on 1=1 /*True*/
>
>does count(tb1) * count(tb2), whereas
>
>select * from table1 full join table2 on 1=0 /*False*/
>
>does count(tb1) + count(tb2)
>
>Though I've never used a full join, and it will be interesting to
>learn whether it helps you with your indexing problem. Inner JOIN is
>completely different from a FULL JOIN and it wouldn't surprise me if a
>FULL JOIN didn't produce an optimal plan for your query. But try and
>tell us the result.
>
>HTH,
>Set
>
>--- In firebird-support@yahoogroups.com, Adomas Urbanavicius wrote:
>
>
>>Where ? I have just tried to do so..
>>Dimitry Sibiryakov wrote:
>>
>>
>>
>>>On 31 Mar 2006 at 14:40, Adomas Urbanavicius wrote:
>>>
>>>
>>>
>>>
>>>
>>>>Yes, and reads from tables : count(tb1) * count(tb2) . no good.
>>>>
>>>>
>>>>
>>>>
>>> Where did you get this stupid idea? Reads will be count(tb1) +
>>>count(tb2) not more.
>>>
>>>
>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>

--

Pagarbiai / Best Regards,
Adomas Urbanavicius
+37068543336