Results 1 to 2 of 2

Thread: Mutli_Pass SQL

  1. #1
    Join Date
    Jun 2005
    Posts
    6

    Unanswered: Mutli_Pass SQL

    What is Multi Pass SQL

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Try using google first before asking a question. I typed "Multi Pass SQL" into google and had a response in 1 second.

    Generating multi-pass SQL breaks the user's query down into a number of simple queries that are processed separately by the database and then automatically grouping the results of the separate queries. This multi-step processing can even be performed in parallel, to the extent that the database is configured to optimise and parallelise these queries as they arrive.

    Answers to a broad range of seemingly innocent queries can only be achieved with multi-pass SQL, where each pass represents a sub-query necessary to calculate the final result.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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