| Dirty database_Performance issues [message #357109] |
Tue, 04 November 2008 00:03  |
neena_forum
Messages: 1
Registered: November 2008
|
Junior Member |
|
|
Hi all
i have the followong situaton
After the many insert, update, and delete operation, the physical address on the disk drive many not be continuous one for some record.
this may affect the performance.
Can anyone help me to resolve this?
Is there any solution for this?
|
|
|
|
|
|
| Re: Dirty database_Performance issues [message #357316 is a reply to message #357123] |
Tue, 04 November 2008 19:36  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Still though, there are benefits to be had from placing rows commonly accessed together in the same database block.
This can be done using a CLUSTER. This is not so popular any more, not least because it means more work for DBAs.
The other way is to rebuild your table periodically:
CREATE TABLE new_table AS
SELECT *
FROM old_table
ORDER BY this_col
Depending on your situation - and the problem you are trying to solve - this may work great or not at all.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
