[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