Re: Function based index on a existing table column

[Peter Brawley]

> Ex : where col1 <= col1 +offset

That's equivalent to a constant expression, ...where offset>0... Did you mean where col1 <= col2 + offset?

> if there is a possibility to add an index on (col1 + offset) without adding a new column ?

You answered your own question: "there are no function based indexes". You'll need a stored derived column, eg offset as (col1-col2) stored.