1. In Oracle 9.2+ you have: "Index skip scans to improve index scans by nonprefix columns since it is often faster to scan index blocks than scanning...
Separate names with a comma.