It also depends on other factors as well, such as:

SP version and service pack level

what databases

SharePoint included a procedure called defragmentIndices after SharePoint 2007 SP2.