SQL_BIG_SELECTS=1
Hello,
I have created a VIEW and when I apply this view I have the followinf message.
Where do I have to setup the value "SQL_BIG_SELECTS=1" whithin my view?
Tkx
#1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Subject
Written By
Posted
SQL_BIG_SELECTS=1
August 20, 2010 05:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.