Other hints provide guidance to the query optimizer regarding when to use indexes to search within tables and the cardinality (the number of rows) of certain tables or intermediate result sets.