Behaves like production
Under the recommended strict profile, a query with no composite index fails as it does in production, with the same error. The few development defaults are documented and can each be switched. See Why Fireemu for a comparison with the Local Emulator Suite.