Hello: I wonder whether the index will give monetdb query more performance or not. For example, like tpc-h queries, if I put index on the particular fields, then the query on over those fields will faster? Thanks & Regards.
Hello You have no control over the indices. They are created/maintained as a side-effect of queries. You can only see the effect between cold and hot runs. regards, Martin On 11/09/14 22:05, Bing Zhang wrote:
Hello:
I wonder whether the index will give monetdb query more performance or not. For example, like tpc-h queries, if I put index on the particular fields, then the query on over those fields will faster?
Thanks & Regards.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks, Professor.
On Thu, Sep 11, 2014 at 4:34 PM, Martin Kersten
Hello
You have no control over the indices. They are created/maintained as a side-effect of queries.
You can only see the effect between cold and hot runs.
regards, Martin
On 11/09/14 22:05, Bing Zhang wrote:
Hello:
I wonder whether the index will give monetdb query more performance or not. For example, like tpc-h queries, if I put index on the particular fields, then the query on over those fields will faster?
Thanks & Regards.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Bing Zhang -
Martin Kersten