Part I :
Provide your response to the following:
Discuss the pros and cons of providing database objects with free space.
Part II:
Respond to the following posts(no criticism).
1.Pros and cons of providing database objects with free space.
COLLAPSE
In some aspectsproviding database objects with free space can be very beneficial because it can reduce the frequency ofrecognization, it is also capable of increasing the efficiency of access and insertion. Since when new rows are inserted in a databasethey are clustered properly.However, the disadvantages ofproviding database objects with free space can be, it will require largerdiskstorage space, scanning will take a longer time.
2.Pros and Cons of Providing Database Objects w/ Free Space
COLLAPSE
The pros of providing database objects with free space includes faster inserts when free space is available,new row inserts being properly clustered,variable-length rows and altered rows have room to expand, potentially reducing the number of relocated rows, and having fewer rows on a page which results in better concurrency because less data is unavailable to other users when a page is locked.
The cons of providing database objects with free space include greater disk storage requirements, longer scans, and fewer rows on apage can necessitate I/O operations to access the requested information.Another disadvantage of providing database objects with free space is the decrease in efficiency of data caching because the number of rows per page decreases and fewer rows are retrieved per I/O.