Re: create a view with parallel hint
Date: Sat, 29 Mar 2008 05:51:39 -0700 (PDT)
>> I can't change the tables parallelism,.. too much impact on the rest
>> of the system. Too risky.
> How about you change the table parallel degree right before you submit the
> report job and immediately change it to noparallel after it? You just need to
Correction to my message. If the query is running, attempting to change the table to noparallel would just hang on library cache lock. The same is true for its index.
Nobody has mentioned "alter session force parallel query". It works even though the table and index involved are noparallel and no hint exists in the SQL. If you can't inject this SQL to Crystal Reports, use a logon trigger, even temporarily.
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ Received on Sat Mar 29 2008 - 07:51:39 CDT