> CREATE INDEX MYINDEX_IDX1
> ON MYTABLE (COLUMN1 ASCENDING, COLUMN2 DESCENDING )

>
> Atenciosamente,
>
> Hugo Eyng
>

Hi,

AFAIK mixing asc desc in same index is not supported
If this is not unique index then create two separate indexes


regards,
Karol Bieniaszewski