SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

index creation

Roshan BisnathNov 22 2024

Oracle Database 19.23

Dear Team,

kindly advise if index can be created on RECORD_STATUS and CO_CODE only?

SELECT RECID FROM A WHERE ( XMLEXISTS('$t[some $d in /row/c82/text() satisfies starts-with($d,$id)]'PASSING "THE_RECORD" as "t", :1 as "id") ) and "RECORD_STATUS" = :2 and "CO_CODE" = :3 ORDER BY RECID

SELECT RECID FROM B WHERE ("RECORD_STATUS" = :1 and "CUSTOMER" = TO_NUMBER(:2 ) or ( XMLEXISTS('$t[/row/c105/text()=$id]' PASSING "THE_RECORD" as "t", TO_NUMBER(:3 ) as "id") )) ORDER BY RECID

Thanks,

Roshan

Added on Nov 22 2024

1 comment

119 views