Results 1 to 2 of 2

Thread: Difference

  1. #1
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    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
    Location
    Near Paris France
    Posts
    60
    Use google Groups as
    http://groups.google.com/groups?hl=f...es.oracle.misc

    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
  •