Method GetIndexFragmentation

GetIndexFragmentation(String, Int64, Int32)

Get index fragmentation

Declaration

List<IndexFragmentationContract> GetIndexFragmentation(string connectionId, long minimumPageCount, int minimumFragmentationLevel)

Parameters

Type	Name	Description
System.String	connectionId	The connection id to identify your connection. See also ConnectionId
System.Int64	minimumPageCount	Only entries with the same page count or more will be returned
System.Int32	minimumFragmentationLevel	Only entries with the same level of fragmentation or more will be returned

Returns

Type	Description
System.Collections.Generic.List<IndexFragmentationContract>	Index fragmentation

Examples

POST http://YourServerName/InfoShare/Json/Server/GetIndexFragmentation

Example for get index fragmentation.

{
    "connectionId": "771f1308-f1c5-41ae-b555-a71b110aa26f",
    "minimumPageCount": "5",
    "minimumFragmentationLevel": "10"
}

Response:

{
  "GetIndexFragmentationResult": [
    {
        "Fragmentation": 96,
        "IndexName": "AuditManager_PK",
        "PageCount": 54,
        "Table": "AuditManager"
    },
    {
        "Fragmentation": 13,
        "IndexName": "DataItem_NU_C_idx1",
        "PageCount": 53,
        "Table": "DataItem"
    }
  ]
}

Exceptions

Type	Condition
ServiceException	The connection id {connectionId} isn't valid or has expired (10008)
ServiceException	Verification code is needed: Verification code not yet verified (10152)