Re: Indexing View Columns?
Date: Thu, 10 Mar 2011 13:30:40 +0000 (UTC)
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
> 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
I would strongly advise to consider alternative design options.