> 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