Hello... simple questions (I think!):

1) having a numeric field, if I want to select all the values > 0, is
better to have an descending index on that field? or just a ascending one?

2) having a date field, if I want to select all the records with null.
It helps to have an index on that field? If so, would it be ascending or
descending?

I know, FB uses the index for selecting nulls of a date field (the plan
analizer shows me that) but I wander if it really helps.

thanks!

-s


[Non-text portions of this message have been removed]