Sure id should be unique, so it's just not a good name for it. You are right.
But testing your query give me also am* empty result* =( FYI: - symbol is FULLTEXT_HASH_INDEX - id is NOTUNIQUE_HASH_INDEX Does that matter? Because of the Indexes, please let's SELECT appln_id FROM Application WHERE ipc_class_symbol CONTAINSTEXT 'B62D' AND ipc_class_symbol CONTAINSTEXT 'B60' Runs much faster. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
