Re: UNION CASTING .

From: Maze Control - Terminal 23315 - Central 2 <trw-sinterface_at_pluto.gwy>
Date: Fri, 27 Apr 2001 19:13:33 +0100
Message-ID: <xDiG6.12201$_W2.12169@news.indigo.ie>

Thanks, tried it. No luck !

Screwdriver out and into the internals I think. "Frank" <franjoe_at_frisurf.no> wrote in message news:11iG6.1163$Ty6.16433_at_news1.oke.nextra.no...
> Hi!
>
> I'm not a very good tuner; but I can supply some ideas :-)
>
> Is it so that your union view is used in a much larger query?
> Try to replace your union view with the a inline view
> along the lines of
>
> change from:
> SELECT col, col, col
> FROM tables,
> v_view_in_trouble
> WHERE stuff
>
> change to
> SELECT col, col, col
> FROM tables,
> (SELECT * FROM ... UNION SELECT * FROM ...)
> WHERE stuff
>
>
> and check if the optimiser comes to any new conlution?
> If it does, perhaps the "merge view" hint could help
>
> Frank
>
>
>
>
>
Received on Fri Apr 27 2001 - 13:13:33 CDT