All Questions
Tagged with fragmentation optimization
4 questions
3
votes
2
answers
13k
views
How can I defragment tables in MySQL?
I have a database named COUNTY. COUNTY has a fragmented table GEO.
I executed OPTIMIZE TABLE GEO against the GEO table, but this returned the error
"Table does not support optimize, doing recreate ...
- 55
9
votes
2
answers
9k
views
Can rebuilding indexes cause worse performance after the rebuild is finished?
We have a customer database that is heavily fragmented - practically every table with more than 1000 pages has >95% fragmentation. Fill factors are set to sensible values, but page space usage is ...
- 199
2
votes
1
answer
648
views
Clustered composite key high fragmentation and fill factor
I've recently made a table to hold the language preferences of my users as follow:
CREATE TABLE [dbo].[systemUserLangPreference](
[systemUserID] [int] NOT NULL,
[langID] [int] NOT NULL,
[...
- 143
10
votes
2
answers
9k
views
REBUILD - Clustered Index, TABLE, or both?
I'm having trouble finding a definitive resource on this anywhere, so hopefully a guru can give me an answer here.
I have a very large table that we had to add a column to. The clustered index is ...
- 18.1k