Support configuration of indexes

[mor619dx]

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]

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,

• Steve