[MonetDB-users] Tweaking performance
123456789012345678901234567890123456789012345678901234567890123456789012
Does anyone have some guidance on approaches for optimizing database performance?
I realize this is a pretty broad question :)
More specifically, I'm running a simple query
select max(date) from metric
on a table with 21 million rows (or whatever you call them in Monet). It's taking quite a bit longer than I'd expect, given a typically indexed column.
On an "explain" I see that there's no difference between the plan with or without the presence of an index on 'date'. Per the SQL index docs, I see that indexes are more of a hint to Monet and they're often ignored.
Cool.
But what happens when I want to fix what seems to be a configuration problem with my database/schema?
Thanks!
Garrett
participants (1)
-
Garrett Smith