I have a table A of type disc_copies. It has two files on the disk.
- A.DCD - last modified time 30th Aug
- A.DCL - today(7th Sep)
As per my understanding, A.DCL is log file and A.DCD has all the data. Today I have done multiple operations on A, however A.DCD remains same but size of A.DCL was increased. When my application starts how this table gets stored in ram when DCD file is not changed. Proper Documentation is not available, so can anyone tell what is the exact process ? Also DCD file gets very large over the time even though there is no data in the table, can anyone clarify ?