Hi I have a table that has (among others) two fields: BL_PREFIX VARCHAR10 BOOKING_NO INTEGER
Column BL_PREFIX will have two, maximum three values I need that following statement should be as fast as possible: SELECT MAX(BOOKING_NO) FROM BOOKINGS WHERE BL_PREFIX = :BL_PREFIX Is the compound descending index (BL_PREFIX, BOOKING_NO) enough for above query? Thanks Marcin