Re: Hints and create table as select

From: Gerard M. Averill <e-mail.address_at_my.sig>
Date: Mon, 15 Feb 99 21:53:47 GMT
Message-ID: <7aa4qu$oak$1@news.doit.wisc.edu>

In article <0685A427A719D11197BB00A024D399450CDA4061_at_delphi.sapient.com>, Jake Battle <jbattl_at_sapient.com> wrote:
>I am having a problem with the CREATE TABLE AS SELECT command under
>8.0.5. I can write a select statement, and it has a good plan (using
>indexes, etc). Once I put the CREATE TABLE AS SELECT in front of it
>however, the plan changes for the worse (starts using more full table
>scans). I have tried to use hints, but they are ignored when I add the
>create table clause. Has anyone else gotten around this?

Jake,
Along with INDEX hints, try adding USE_NL hints as well. This has done the trick for me.

Gerard

---

Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison GAverill<at>chsra<dot>wisc<dot>edu Received on Mon Feb 15 1999 - 15:53:47 CST