Stack Overflow
Stack Overflow

Questions tagged [database-fragmentation]

14 questions
12
votes
5 answers

Reduce SQL Server table fragmentation without adding/dropping a clustered index?

I have a large database (90GB data, 70GB indexes) that's been slowly growing for the past year, and the growth/changes has caused a large amount of internal fragmentation not only of the indexes, but of the tables themselves. It's easy to resolve…
SqlRyan
  • 33,116
  • 33
  • 114
  • 199
7
votes
1 answer

SQL Server Fragmentation Problems

I have a couple of tables (User & UserRecord) in my database that get extremely fragmented (like 99%) and cause the whole database and therefore the website to grind to a halt. UserRecord is kind of like a snapshot of that user at a point in time.…
Owen
  • 4,229
  • 5
  • 42
  • 50
6
votes
3 answers

Sequential Guid and fragmentation

I'm trying to understand how sequential guid performs better than a regular guid. Is it because with regular guid, the index use the last byte of the guid to sort? Since it's random it will cause alot of fragmentation and page splits since it will…
pdiddy
  • 6,217
  • 10
  • 50
  • 111
5
votes
1 answer

Primary Horizontal Fragmentation in DDBMS- Completeness of simple predicate

"An important aspect of simple predicates is their completeness; another is their minimality. A set of simple predicates Pr: is said to be complete if and only if there is an equal probability of access by every application to any tuple belonging to…
user1864163
  • 53
  • 1
  • 5
3
votes
3 answers

How do I know if a table in Oracle is fragmented?

I have a table which seems to be taking up more space than it needs to. I have been advised to copy the data to a new table and rename the new table and old table to swap them. How can I confirm if a current table is actually fragmented? How can I…
Stuart Woodward
  • 2,138
  • 4
  • 21
  • 31
2
votes
1 answer

Do we still need to worry about row fragmentation when using flash disk storage?

Row fragmentation was always a thing you needed to think about when choosing char/varchar2 data types for table columns, issuing batch deletes/inserts/updates on the tables because Oracle tries to fit new data into opened free spaces and so…
Centurion
  • 14,106
  • 31
  • 105
  • 197
2
votes
2 answers

Database Index Fragmentation: Sequential GUID saved as String works fine but not saved as GUID

We are using GUID as primary key (we know it's not good option, but can not change now). So as all know our indexes get fragmented very quickly. Another good option to replace the GUID by Sequential ID. To do this, Code change is like: Old Code…
PM.
  • 1,735
  • 1
  • 30
  • 38
1
vote
5 answers

Wordpress & MySQL table fragmentation

So, I'm using Wordpress, MySQL (8.0.16), InnoDB. The wp_options table normally is 13 MB. The problem is, it suddenly (at least within a span of a few days) becomes 27 GB and then stops growing, because there's no more space available. Those 27 GB…
Alexander Mikhalchenko
  • 4,525
  • 3
  • 32
  • 56
1
vote
1 answer

Index fragmentation growing rapidly even using fillfactor

I am using SQL Server 2012, from few days I have noticed that fragmentation of some indexes are growing very rapidly. I have read different article and apply the fill factor. First I have change the fill factor to 95 and rebuild, after one day…
Techleadz Team
  • 198
  • 2
  • 15
1
vote
1 answer

High extent scan fragmentation but low Logical Scan Fragmentation

I'm still new to SQL Server, when I run DBCC SHOWCONTIG on table, it shows that Logical Scan Fragmentation is not big but Extent Scan Fragmentation is big, which made me a little confused. DBCC SHOWCONTIG scanning 'User' table... Table:…
Felix
  • 149
  • 11
1
vote
2 answers

Creating an 'archive table'

I have a table that will contain, let's say, tasks. Some tasks are new or in work-in-progress stage, but other tasks will be in archive stage which means they have been dealt with and the chance of going back to them is low. I was thinking that…
prince
  • 671
  • 2
  • 11
  • 26
1
vote
3 answers

SQL Server insertion performance

Let's suppose I have the following table with a clustered index on a column (say, a) CREATE TABLE Tmp ( a int, constraint pk_a primary key clustered (a) ) Then, let's assume that I have two sets of a very large number of rows to insert to…
soleiljy
  • 1,121
  • 2
  • 13
  • 20
0
votes
1 answer

What is Index fragmentation in Oracle SQL?

Can anyone explain what index fragmentation is? I googled Index Fragmentation but couldn't find satisfactory answer.
llecxe
  • 113
  • 1
  • 4
0
votes
0 answers

Horizontal Fragmentation Approach in cluster replication configuration in ubuntu linux

I am new in master-slave replication and horizontal fragmentation technique. Currently, I am doing my final year degree project title "Cluster replication using horizontal fragmentation approach". This is my use case: There are 4 virtual machines.…
izzati Aziz
  • 1
  • 2