victor-yeung001 commented on issue #35197: URL: https://github.com/apache/superset/issues/35197#issuecomment-3403436875
Hi again, we've been thinking of a solution and just wanted to ask some questions about our approach. We are planning to wrap the query in another query to set the limit instead of the FETCH FIRST behavior. Currently we are deciding between using the ROWNUM syntax for all Oracle versions or making it so that only versions 11 and under use the ROWNUM syntax. While trying to figure out how to do a version specific implementation we were concerned that if we try to retrieve the Oracle version at the same time as the query is made, that performance would suffer. This is why we thought of using ROWNUM for everything instead. We would really appreciate some feedback. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
