Dmitry,
We create indexes programmatically and we we generate their names based on
their definition, such the columns they index. In fact the plan I am trying
to force the query optimizer to use is exactly the plan that was generated
by query optimizer when I replaced INNER with LEFT JOIN in the query.
COPY is the name of the table.
The question is why FB complains about PLAN token after ORDER BY clause?
Thanks,
Alec
On Sat, Jun 2, 2012 at 2:31 PM, Dmitry Kuzmenko <k...@ibase.ru> wrote:
> **
>
>
> Hello, Alec!
>
> Saturday, June 2, 2012, 11:28:52 PM, you wrote:
>
> AS> specify a plan for a query that has ORDER BY clause. I get a "invalid
> AS> token PLAN" error if I specify the plan after ORDER BY, but it works
>
> AS> COPY INDEX ("PK_ZM6SRonqR8AHSQuCISgvnQ=="))
>
> and, finally, who told you about "COPY" word in a plan,
> or where you got it?
>
> --
> Dmitry Kuzmenko, www.ib-aid.com
>
>
>
[Non-text portions of this message have been removed]
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org 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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
