Comment
13-06-2021
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
The queryDef's translate into ordinary sql, js isn't used (outside interaction which doesn't have startLine attrib).
For most* rdbms' this would add 'limit n offset m' along with whatever optimizations available, such as 'top' hint for ms sql server.
The reason your queries are running faster when you add indexed conditions is they aren't scanning the full table for results.
Thanks,
-Jon
*Most since mysql uses diff syntax but is long deprecated as an acc install option. I think db2 is also weird but also deprecated now?