-
Dear Friends
as you know if i am saving 1 record or 1000000 rows it
will take same time. can any body guide me how iternally
it will work.
Rakesh Sanghvi
-
I can tell you that to insert one row of data, not only must Oracle create Rollback information it must also run about 4 other queries updating the data dictionary, update any indexes, store all this information in the rollback segment as well. If a rollback segment needs more extents these must be allocated and again the data dictioanry must be updated.
In short a simple insert is far from simple.
To insert 100000 rows is the same thing. You just need a bigger rollback segment.
There is probably more to it. I read a book once that dedicated a chapter to what happens when you insert a row. You'd be surprised.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|