Re: Indexing View Columns?

From: Mladen Gogala <>
Date: Thu, 10 Mar 2011 13:30:40 +0000 (UTC)
Message-ID: <>

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.

Received on Thu Mar 10 2011 - 07:30:40 CST

Original text of this message