Re: indexing on every column?

[Phil Smy]

Thanks Ben!

Unfortunately the data is fast and furious on inserts AND selects! I am going to try and pair down the column sizes.

I do have an index on starting_time which does seem to help. BUT that index doesn't seem to get used when doing:
starting_time > x and starting_time < y for some reason (not does it get used when doing a between) if I also have 'and id = z' in there.

I guess I was hoping for a 'oh, just do this!' answer :-)

Thanks again - more investigation warranted.