![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
![]() |
Wed, May 6 2015 10:09 AM | Permanent Link |
Ideal Software Systems | 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. |
Wed, May 6 2015 10:35 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Ideal
Without seeing it or your database/table structure I'd guess its suggesting an index on one of the tables involved. Roy Lambert |
Wed, May 6 2015 12:16 PM | Permanent Link |
Ideal Software Systems | > 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. |
Wed, May 6 2015 12:49 PM | Permanent Link |
Matthew Jones | 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 |
Thu, May 7 2015 2:13 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Sat, May 9 2015 4:06 PM | Permanent Link |
Barry | 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 |
Fri, May 15 2015 10:23 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Fri, May 15 2015 12:45 PM | Permanent Link |
Barry | "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 |
This web page was last updated on Wednesday, July 2, 2025 at 06:46 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |