I have a query plan that is telling me that I should create an index on a view that I'm selecting from.  

Does Elevate allow indexes on views?  I understood that it does not.

Ideal


Without seeing it or your database/table structure I'd guess its suggesting an index on one of the tables involved.

Roy Lambert

> Without seeing it or your database/table structure I'd guess its suggesting an index on one of the tables involved.

The field mentioned in the query plan is indexed in the table itself.

Ideal Software Systems wrote:

> > Without seeing it or your database/table structure I'd guess its
> > suggesting an index on one of the tables involved.
>
> The field mentioned in the query plan is indexed in the table itself.

Is is the right type of index? I fell over that one in normal SQL - I
can't remember the different types, perhaps case sensitive or not.

--

Matthew Jones

Matthew

>Is is the right type of index? I fell over that one in normal SQL - I
>can't remember the different types, perhaps case sensitive or not.

Me too. Collation, case sensitivity, ascending or descending I think covers it.

Roy

Ideal Software Systems wrote:

>The field mentioned in the query plan is indexed in the table itself.<

The view WILL use the index of the underlying table when possible. The query plan often does not report this correctly.

Barry

Barry,

<< The query plan often does not report this correctly.  >>

Do you mean "won't report it at all because it's a view and not part of the
current query" ?

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Barry,

<< The query plan often does not report this correctly.  >>

<Do you mean "won't report it at all because it's a view and not part of the
current query" ?>

Yes. It will display a hint to build an index for a column in the view, but the underlying table of the view already has an index on that column.

Barry

v2.13b2