Index Seek
Great! Just what I wanted.
There is one statement in that post I am not in agreement with - The one who posted the question says
We just create index and all filters on record set containing indexed fields automatically uses index
How will the index be 'automatically' used if a field name is used? Unlike in an RDBMS, in HPCC, index would be used only if we explicitly use the attribute name (defined earlier for the index), isn't it? Pls. clarify.
There is one statement in that post I am not in agreement with - The one who posted the question says
We just create index and all filters on record set containing indexed fields automatically uses index
How will the index be 'automatically' used if a field name is used? Unlike in an RDBMS, in HPCC, index would be used only if we explicitly use the attribute name (defined earlier for the index), isn't it? Pls. clarify.
- Gayathri_Jayaraman
- Posts: 75
- Joined: Wed May 08, 2013 5:03 am
Gayathri,
HTH,
Richard
Clarification is easy -- you're correct.There is one statement in that post I am not in agreement with - The one who posted the question says
We just create index and all filters on record set containing indexed fields automatically uses index
How will the index be 'automatically' used if a field name is used? Unlike in an RDBMS, in HPCC, index would be used only if we explicitly use the attribute name (defined earlier for the index), isn't it? Pls. clarify.
HTH,
Richard
- rtaylor
- Community Advisory Board Member
- Posts: 1619
- Joined: Wed Oct 26, 2011 7:40 pm
12 posts
• Page 2 of 2 • 1, 2
Who is online
Users browsing this forum: No registered users and 1 guest