- Log in to post comments
User bio
404 bio not found
Member since Oct 23, 2023
Posts:
Replies:
Hmm, that's not what I would have expected. I'm going to ask around and see if there's something I'm missing here, but in the meantime can you try running TUNE TABLE on this table and see if that changes the behavior/query plans at all? https://docs.intersystems.com/iris20253/csp/docbook/DocBook.UI.Page.cls…
- Log in to post comments
Comparing the two, it does look like the slower query is performing a full table scan for some reason, which is very odd. What type of index is row_status_idx? If it is not a bitmap index, could you try adding an additional bitmap index on the field (or changing the type of the index to bitmap)?
- Log in to post comments
Certifications & Credly badges:
Nick has no Certifications & Credly badges yet.
Followers:
Following:
Nick has not followed anybody yet.
Use 'Return' instead: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_creturn
In general, if you're trying to exit a method and return a value to the caller, 'Return' is the best way to do that, as 'Quit' also has functionality for control flow (such as breaking out of WHILE loops).