Performance issue when using a Local Storage table with 100K rows in joins
説明
In a scenario when there is an Excel file with 100,000 rows and over 30 columns, added to Local Storage database, and you run a cross connection query with an Oracle database table, which has millions of rows, the way Toad Data Point is constructing the query in Query Builder is not pushing the filters to the database, and would result in 300k rows to search through.