Defragmentation Problem

[Aman786Singh]

I have a table containing 1 crore tuples(rows). At the creation time , i have applied indexes on it. Should i defrag it peiodically ?? Only the Select Operation is performed on it.. Kindly suggest...

[Lost User]

Aman786Singh wrote:

Only the Select Operation is performed on it

It won't get fragmented indeed, since you - only read from it - are using a database, not a file-system Hope this helps :)

I are troll :)

[Luc Pattyn]

Eddy Vluggen wrote:

are using a database, not a file-system

you expect a read-only file-system to get fragmented over time? :)

Luc Pattyn [Forum Guidelines] [My Articles]

---

- before you ask a question here, search CodeProject, then Google - the quality and detail of your question reflects on the effectiveness of the help you are likely to get - use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

---

[Lost User]

:laugh: I was thinking that there's no "defrag.exe" for databases! And I bet that somewhere, someone will have written such a thing :)

I are troll :)

[Aman786Singh]

WHEN I RAN INDEXDEFFRAG.. THEN WHAT THIS RESULT MEANS??? PAGE SCANNED PAGE MOVED 245 0

[Lost User]

You were right :) "DBCC INDEXDEFRAG defragments the leaf level of an index so that the physical order of the pages matches the left-to-right logical order of the leaf nodes, thus improving index-scanning performance."

I are troll :)