Question : I ran the following query on my database to identify the fragmented indexes. However I surprised when saw […]
Tag: fragmentation
What is “Index Fragmentation Percent” a percentage of?
Question : I am familiar with the concept of index fragmentation and how to fix it, but I’m not really […]
Find out when your index was last rebuilt / reorganized
Question : I’ve recently come across a database, which has very high fragmentation on large tables. Page count > 1’000’000 […]
Checking database files for physical fragmentation
Question : I searched the Internet and did not find clear explanation for when I should try defragmenting physical database […]
Is this database fragmentation or something else? What can be done?
Question : I have the table below in PostgreSQL (automagically generated with insertions using Marten): create table mt_doc_order ( id […]
Is concept of fill factor useful only when index is rebuilt?
Question : Fill factor is concept that works only when creating a new index or when the index is rebuilt. […]
Model for Distributed Database [closed]
Question : It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or […]
What’s better for large changes to a table: DELETE and INSERT every time or UPDATE existing?
Question : I am making a project where I need to change around 36K records in one table daily. I’m […]
Will frequent creation and deletion of TABLE (not indexes) cause fragmentation in database?
Question : Does frequent creation and deletion of physical table in database causes fragmentation? I am frequently creating and deleting […]
What is the cause of high index fragmentation in SQL server?
Question : We have an application which is using a SQL Server database. As the application is in use for […]