When Does Fragmentation Occur ?

1.	When Does Fragmentation Occur ?
Answer» FRAGMENTATION is likely to occur with the following: 1. Read/write databases that users are constantly updating with data 2. Databases that EXECUTE calculations around the CLOCK 3. Databases that frequently update and recalculate dense members 4. Data loads that are poorly designed 5. Databases that contain a significant number of Dynamic Calc and STORE members 6. Databases that use an isolation level of uncommitted access with commit block set to zero Fragmentation is likely to occur with the following: 1. Read/write databases that users are constantly updating with data 2. Databases that execute calculations around the clock 3. Databases that frequently update and recalculate dense members 4. Data loads that are poorly designed 5. Databases that contain a significant number of Dynamic Calc and Store members 6. Databases that use an isolation level of uncommitted access with commit block set to zero

Answer»

FRAGMENTATION is likely to occur with the following:

1. Read/write databases that users are constantly updating with data

2. Databases that EXECUTE calculations around the CLOCK

3. Databases that frequently update and recalculate dense members

4. Data loads that are poorly designed

5. Databases that contain a significant number of Dynamic Calc and STORE members

6. Databases that use an isolation level of uncommitted access with commit block set to zero

Fragmentation is likely to occur with the following:

1. Read/write databases that users are constantly updating with data

2. Databases that execute calculations around the clock

3. Databases that frequently update and recalculate dense members

4. Data loads that are poorly designed

5. Databases that contain a significant number of Dynamic Calc and Store members

6. Databases that use an isolation level of uncommitted access with commit block set to zero

Discussion