Re: index on a view

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 21:00:59 +0100

On Thu, 17 Feb 2005 15:48:06 GMT, cmarano wrote:

>Hello,
>I have a table (TAB) and A View with alias (VIEW)
>
>Table cod varchar 3
> descr carchar 60
>
>
>my view cod alias COd1
> descr alias DES
>
>Now i need a index on view with key COD1
>
>I can't create it.
>
>Can you help me

Hi Carlo,

I think I can help you, but first I need to get a better picture of what
you're trying to achieve.

What I read from your message is that you have a view that is simply the
same as your table, but with different column names, and that you are now
trying to index that view. I hope that I have misread you, though, as this
would simply result in the same data redundantly being stored at two
different locations in the database.

The best way to clarify your problem is to post:
* Actual table structure, as CREATE TABLE statements - please include all
constraints and all properties (see www.aspfaq.com/5006)
* Some rows of illustrative sample data to give me an idea of the kind of
data you're handling (posted as INSERT statements)
* The CREATE VIEW statement used to create the view you want to index
* The reason for wanting to index your view (in other words: what are you
hoping to achieve)

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)