Wed Oct 28, 2020 8:53 pm
Login Register Lost Password? Contact Us


Index Seek

Questions and comments regarding the Online Lessons should be posted here.

Tue Oct 08, 2013 9:28 am Change Time Zone

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.
Gayathri_Jayaraman
 
Posts: 75
Joined: Wed May 08, 2013 5:03 am

Tue Oct 08, 2013 1:07 pm Change Time Zone

Gayathri,
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.
Clarification is easy -- you're correct.

HTH,

Richard
rtaylor
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1566
Joined: Wed Oct 26, 2011 7:40 pm

Previous

Return to Online Classroom

Who is online

Users browsing this forum: No registered users and 1 guest