How do I most efficiently query large SuiteQL tables like system notes or transaction lines? We are having performance issues on those tables

AI generated answer (using internal Slack threads):

To efficiently query large SuiteQL tables like system notes or transaction lines, you can follow these steps: 1. **Avoid using SELECT :* When querying large tables, avoid using SELECT * as it can significantly slow down your query. Instead, specify the exact columns you need in your SELECT statement. This reduces the amount of data that needs to be processed and returned, which can improve performance. 2. Use the Query Module: The Query Module (N/query) in SuiteScript allows you to retrieve up to 5,000 records at a time. It has been reported to be faster than the Search API in some cases. 3. Use Indexes: If you're querying on specific columns frequently, consider using indexes on those columns to speed up your queries. However, keep in mind that while indexes can speed up read operations, they can slow down write operations (inserts, updates, deletes) because the index also needs to be updated. 4. Limit the Number of Joins: If your query involves multiple joins, try to limit the number of joins as much as possible. Each join can add significant overhead to your query. If you need to join multiple tables, consider whether you can achieve the same result with multiple simpler queries instead. 5. Use the Records Catalog: The Records Catalog in NetSuite can show you all the joins and cardinality for a table. This can help you understand the structure of your data and optimize your queries. Remember, the performance of your queries can also be affected by factors outside of your control, such as the current load on the NetSuite servers. If you're experiencing consistent performance issues, it may be worth discussing this with your NetSuite administrator or consultant. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******