Results 1 to 2 of 2

Thread: Difference

  1. #1
    Join Date
    Jan 2003
    The Netherlands

    Unanswered: Difference

    I make two query's, with both a lot of joins and both the same functionality. I have one query with the old join-syntax and one with the new ISO/ANSI syntax. hey have the same execution_plan but when i watch it with the following:
    select * from v$sqlarea where or sql_text like '%PPPPP%'
    ( I put '%PPPPP%' in the query to extract it from the table. )

    I see that my shared_memory is 60 time as big my runtime_mem is 7 times as big and the cpu time is 80 times as big. So the new ANSI/ISO goes slomo in comparison with the old syntax, but they use the same execution plan. does anyone give me a hint?

  2. #2
    Join Date
    Jul 2003
    Near Paris France
    Use google Groups as

    A lot of High specialists may give you an answer,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts