DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ambigous results SELECT/Insert-SELECT

  1. #1
    Join Date
    May 2002
    Posts
    108

    Unhappy Ambigous results SELECT/Insert-SELECT

    Hi

    When I execute a SELECT query it returns 580 records.

    When I use the same query in the INSERT statement "INSERT INTO SELECT..." it populates 616 records.

    The table into which it is inserted in empty.

    Materialized views are part of the SELECT query. So we removed he materialized views and created tables instead. The problem seemed to be resolved temporarily. But it popped up again now with the tables itself.

    I am unable to comprehend the actual problem. Have any of you faced similar problems or any pointers to the issue?

    Cheers
    Nandu
    Last edited by nandu; 11-16-2006 at 01:44 AM.
    Never give up !

    Nanda Kumar - Vellore

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Please do explain plan for both and post the result here. It can give an idea about what happens. The queries would be useful as well

    Regards

  3. Posting Permissions

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


    Click Here to Expand Forum to Full Width