Re: Indexing View Columns?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 10 Mar 2011 13:30:40 +0000 (UTC)
Message-ID: <pan.2011.03.10.13.30.40_at_gmail.com>
On Thu, 10 Mar 2011 04:50:11 -0800, NewUser2008 wrote:
Date: Thu, 10 Mar 2011 13:30:40 +0000 (UTC)
Message-ID: <pan.2011.03.10.13.30.40_at_gmail.com>
On Thu, 10 Mar 2011 04:50:11 -0800, NewUser2008 wrote:
> Is there any way to go around this issue? Like indexing the col2 or
> giving
> it a hint on which UNION line to use?
Indexing column in a view? Sure, as soon as it is possible to assign
rowid to the rows of a view. Not a problem, as long as the view is
materialized.
I would strongly advise to consider alternative design options.
-- http://mgogala.byethost5.comReceived on Thu Mar 10 2011 - 07:30:40 CST