Hello,
First, let me apologize for my flurry of emails as of late... I'm working
on something which seems particularly difficult (at least to me)...
My question is regarding creating an index on a view, or perhaps another
way to accomplish this. For example:
CREATE TABLE table1 (
table1_id
Net Virtual Mailing Lists wrote:
My question is regarding creating an index on a view, or perhaps
another way to accomplish this.
Views are just macro expansions of queries (in a manner of speaking).
To make queries on views use indexes, you create the indexes on the
underlying tables in the
Virtual Mailing Lists
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Creating index on a view?
Net Virtual Mailing Lists wrote:
My question is regarding creating an index on a view, or perhaps
another way to accomplish this.
Views are just macro expansions of queries (in a manner of speaking
The problem in my case is that the view does a join between table2 and
table3 and I want to do a select on a value from table2. So at the point
the expansion happens, I am actually doing a query on a column that does
not exist in table3 - it only exists in table2.
Given what you said, perhaps a
Net Virtual Mailing Lists wrote:
CREATE TABLE table2 (
table2_id INTEGER,
table2_desc VARCHAR,
table3_id INTEGER[]
);
CREATE TABLE table3 (
table3_id INTEGER,
table3_desc VARCHAR
);
What I need is an indirect index (for lack of a better phrase) that
allows me to do:
SELECT b.table3_id,