Hello,

j> can some one explain why you need am index sorted in descending order
j> for the max() function go create a plan that uses the index. the
j> same holds true for the min() function and ascending indexes.
It relates to physical index structure: FB indices are "one way". FB2
(will) have improvements, as I heard.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com