Thank you for your answer.
But in general I would like to know how to get the query exexution time without printing the results. It's for performance comparaison. I want to evaluate MonetDB for my research and i'm working with large tables.
Please any idea??
Greetings,
Baraa
HiOn 10/13/13 10:55 AM, baraa Mohamad wrote:
Hello dear MontDB users,
I have a question please, I just need to get the query execution time
without showing the results of the query (for performance comparaison) .
Something which corresponds to the "traceonly" in Oracle. that will be
greate if I can see the query plan but for the moment the most important
for me is to get the query execution time.
for example: I want to know the query exection time of this query
(select * from source where a>10) knowing that I have more than one
This is not the ind of query you fire when you expect a large outcome.Better use SELECT COUNT(*)....hundred million records which correspond to this predicate.
Thank in advace for your appreciated help.
Baraa
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________users-list mailing listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list