description: Will be nice to see on-line defragmentation feature of database pages.

now in working database - pages are allocated when new data are inserted
e.g we indert data to table A then we insert data in table B and once again some portion of data to table A
and when new pages are allocated we have some pages of table A then some pages of table B and once again some pages of table A

after few days pages of tables and indexes are totally fragmented
becaouse of that when we read data from some table we have a lot of disk head move

will be a nice to have possibility to defragment database pages without taking database off-line

=>

Will be nice to see on-line defragmentation feature of database pages.

now in working database - pages are allocated when new data are inserted
e.g we insert data to table A then we insert data in table B and once again some portion of data to table A
and when new pages are allocated we have some pages of table A then some pages of table B and once again some pages of table A

after few days pages of tables and indexes are totally fragmented
becaouse of that when we read data from some table we have a lot of disk head move

will be a nice to have possibility to defragment database pages without taking database off-line

description: Will be nice to see on-line defragmentation feature of database pages.

now in working database - pages are allocated when new data are inserted
e.g we insert data to table A then we insert data in table B and once again some portion of data to table A
and when new pages are allocated we have some pages of table A then some pages of table B and once again some pages of table A

after few days pages of tables and indexes are totally fragmented
becaouse of that when we read data from some table we have a lot of disk head move

will be a nice to have possibility to defragment database pages without taking database off-line

=>

Will be nice to see on-line defragmentation feature of database pages.

now in working database - pages are allocated when new data are inserted
e.g we insert data to table A then we insert data in table B and once again some portion of data to table A
and when new pages are allocated we have some pages of table A then some pages of table B and once again some pages of table A

after few days pages of tables and indexes are totally fragmented
because of that when we read data from some table we have a lot of disk head move

will be a nice to have possibility to defragment database pages without taking database off-line

priority: Major [ 3 ] => Minor [ 4 ]

Version: 2.5 Beta 2 [ 10300 ]

Version: 3.0 Beta 1 [ 10332 ]

Version: 3.0 Beta 1 [ 10332 ] =>

Version: 2.5 Beta 2 [ 10300 ] =>

Version: 3.0 Initial [ 10301 ]

Version: 3.0 Alpha 1 [ 10331 ]

Version: 3.0 Beta 1 [ 10332 ]

Version: 3.0.0 [ 10048 ]

Component: GFIX [ 10004 ]

Version: 3.0 Initial [ 10301 ] =>

Version: 3.0 Alpha 1 [ 10331 ] =>

Version: 3.0 Beta 1 [ 10332 ] =>

Version: 3.0.0 [ 10048 ] =>