-
Update table performance
Is it faster to update a row in the table by using the primary key in the where clause or the rowid???
-
-
Even though using rowid to update a table is possible, you should not use it in your application.
Example:
In an IOT, rowid changes depending upon the row insertions in the leaf block. In that case, if you use rowid for update, you will be updating wrong rows.
Tamil
-
Originally posted by tamilselvan
Even though using rowid to update a table is possible, you should not use it in your application.
Example:
In an IOT, rowid changes depending upon the row insertions in the leaf block. In that case, if you use rowid for update, you will be updating wrong rows.
Tamil
Better to say that there are limited situations where it is inadvisable ... for example when updating IOT's or rows in partitioned tables where row migration is possible. In the case of IOT's however an update on PK will be faster than with a heap table so there is less incentive to use an update by rowid anyway.
Other than that though, there's nothing wrong with using rowid.
-
Should I say "Using ROWID for UPDATE is NOT portable across different RDBMSs" ?
Tamil
-
why should it matter? you shouldnt be writing RDBMS independant code - a big cause of performance problems
-
Originally posted by tamilselvan
Should I say "Using ROWID for UPDATE is NOT portable across different RDBMSs" ?
Tamil
You can say it, but as Davey says I wouldn't consider it a reason not to do it .
-
==========
why should it matter? you shouldnt be writing RDBMS independant code - a big cause of performance problems
==========
Peoplesoft and Siebel do not write independent codes for each RDBMS.
Tamil
-
No wonder Siebel performance is pretty disgusting often times.
-
I believe I read Tom Kyte saying that "Database independence is a way of getting poor performance on one database and worse performance on others", or something like that. Summed it up pretty well.
Anyway, I missed the bit where lesstjm said that he wanted database independant code.
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
|