If I have a column, say, invoice_id and it is based on a sequence, it is generally a good idea to have a Reverse Key Index rather than normal B-Tree index. However, Reverse Key Index is not good for queries based on a range of invoice_ids. So what do I do if I need to support for a query based on a range of invoice_ids? Can I have two indexes on the column? If so, can I specify which index to use in the query?

Better yet, does anybody have a better solution?

Thanks