Home Forums Article Discussions Article Discussions by Author Discuss content posted by Brian Ellul Sub query expressions vs. Joins. RE: Sub query expressions vs. Joins.

  • July 22, 2010 at 4:25 am

    #1196729

    bayudw, i think the row_number() solution will be faster than the query you currently use. check it out and share the execution time/plan.

    - arjun

    https://sqlroadie.com/