Ent heavily uses joins and does support multi field indices, you should read up on the docs. You can show the queries it’s running using a debug client.
It’s not a Graph DB under the hood and uses any normal relational db quite normally beneath the DX
It’s not a Graph DB under the hood and uses any normal relational db quite normally beneath the DX