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:

> 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.com

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