[ https://issues.apache.org/jira/browse/SPARK-33979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuming Wang updated SPARK-33979: -------------------------------- Description: Reorder filter predicate to improve query performance: {noformat} others < In < Like < UDF/CaseWhen/If < Inset < LikeAny/LikeAll {noformat} https://www.ibm.com/support/knowledgecenter/SSSHTQ_8.1.0/com.ibm.netcool_OMNIbus.doc_8.1.0/omnibus/wip/admin/reference/omn_adm_per_optimizationrules.html#omn_adm_per_optimizationrules__reorder https://docs.oracle.com/en/database/oracle/oracle-database/21/addci/extensible-optimizer-interface.html#GUID-28A4EDA6-19DD-4773-B3B8-1802C3B01E21 https://docs.oracle.com/cd/B10501_01/server.920/a96533/hintsref.htm#13676 was: Reorder filter predicate to improve query performance: {noformat} others < In < Like < UDF/CaseWhen/If < Inset < LikeAny/LikeAll {noformat} https://www.ibm.com/support/knowledgecenter/SSSHTQ_8.1.0/com.ibm.netcool_OMNIbus.doc_8.1.0/omnibus/wip/admin/reference/omn_adm_per_optimizationrules.html#omn_adm_per_optimizationrules__reorder https://docs.oracle.com/en/database/oracle/oracle-database/21/addci/extensible-optimizer-interface.html#GUID-28A4EDA6-19DD-4773-B3B8-1802C3B01E21 > Filter predicate reorder > ------------------------ > > Key: SPARK-33979 > URL: https://issues.apache.org/jira/browse/SPARK-33979 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.2.0 > Reporter: Yuming Wang > Priority: Major > > Reorder filter predicate to improve query performance: > {noformat} > others < In < Like < UDF/CaseWhen/If < Inset < LikeAny/LikeAll > {noformat} > https://www.ibm.com/support/knowledgecenter/SSSHTQ_8.1.0/com.ibm.netcool_OMNIbus.doc_8.1.0/omnibus/wip/admin/reference/omn_adm_per_optimizationrules.html#omn_adm_per_optimizationrules__reorder > https://docs.oracle.com/en/database/oracle/oracle-database/21/addci/extensible-optimizer-interface.html#GUID-28A4EDA6-19DD-4773-B3B8-1802C3B01E21 > https://docs.oracle.com/cd/B10501_01/server.920/a96533/hintsref.htm#13676 -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org