binarycat0 commented on PR #2465: URL: https://github.com/apache/polaris/pull/2465#issuecomment-3242590768
@singhpk234 My colleagues and I conducted several different experiments and we didn't notice significant improvement on the API side. This is most likely primarily dependent on `EntityCache`, which greatly improves performance in the current implementation. Therefore, I can say that the current changes don't significantly improve API performance, but the additional DB INDEX improves SQL experience and reduces query execution time. Also, in my tests I didn't notice a difference when measuring EXPLAIN PLAN for (select *) versus (select colA, colB...) -- 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: issues-unsubscr...@polaris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
