Home » RDBMS Server » Performance Tuning » Dirty database_Performance issues
Dirty database_Performance issues [message #357109] Tue, 04 November 2008 00:03 Go to next message
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 #357123 is a reply to message #357109] Tue, 04 November 2008 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does not matter. In modern system with disk array and RAID technology, you never know where data are on disk and most often they are never contiguous.

Re: Dirty database_Performance issues [message #357316 is a reply to message #357123] Tue, 04 November 2008 19:36 Go to previous message
Messages: 3727
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:
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
Previous Topic: Purgeing data
Next Topic: Index a system view
Goto Forum:

Current Time: Thu Aug 17 16:43:43 CDT 2017

Total time taken to generate the page: 0.08527 seconds