2010/2/5 Wojtek <foo@twine.pl>:
> Most of my queries will have where conditions on timedate and sys_device_id, but a lot of them will have additional
clause:where usefields is not null. Some of the queries will be limited on timedate only.
What about a partial index on (timedate) WHERE usefields IS NOT NULL;
or maybe on (timedate, sys_device_id) WHERE usefields IS NOT NULL?
...Robert