Not all the records getting inserted through a recursive view

Database
Enthusiast

Not all the records getting inserted through a recursive view

Hi

I am having a recursive view and the "select" of the recursive view is pulling 11367034 records.

I have a table in my user db.  From this recursive view am trying to insert into my user_db.table1.

Only 74697 records got inserted.  Why ? 

The table is not having any UPI - it is all PI only... so, why are a bulk of records getting filtered ?

Please help me.. This is needed urgently..!!

  • recursive insertion

Accepted Solutions
Senior Apprentice

Re: Not all the records getting inserted through a recursive view

Your target table is probably a SET table removing duplicate rows during the Insert.

 

Dou you really want those duplicate rows?

Otherwise you might also check your logic because less than 1% of the rows are unique and the recursion could be much more efficient without processing them.

1 ACCEPTED SOLUTION
2 REPLIES
Senior Apprentice

Re: Not all the records getting inserted through a recursive view

Your target table is probably a SET table removing duplicate rows during the Insert.

 

Dou you really want those duplicate rows?

Otherwise you might also check your logic because less than 1% of the rows are unique and the recursion could be much more efficient without processing them.

Enthusiast

Re: Not all the records getting inserted through a recursive view

Thanks a lot Dieter..!! :) I have made the change and the records are getting inserted in it now .