search

mongodb / docs-bi-connector

17 stars 63 forks source link

Support configuration of indexes #246

Open mor619dx opened 4 years ago

mor619dx commented 4 years ago

Hello,

I've searched through the docs and couldn't find any mention of how (or if possible) to create indexes in the MongoDB bi connector MySQL table it creates.

I would have assumes it would be part of the schemas but couldn't find any mention about it.

I'm mainly trying to create indexes to improve my performance over many relations between many tables, Any other suggestion as to how to improve performance?

steveren commented 4 years ago

BI Connector doesn't create any MySQL tables. It provides a way to query MongoDB collections with SQL, or with reporting tools such as Tableau and PowerBI. Creating indexes on your MongoDB collections may improve query performance, but you should do that with the MongoDB shell, not through BI Connector.

Best regards,