They're often terrible at optimizing query plans, especially when there's no index, since the index provides data about the data (cardinality, for example) into

They're often terrible at optimizing query plans, especially when there's no index, since the index provides data about the data (cardinality, for example) into the query optimizer.