>>A cursor is created in SYS(2023) directory but it may not have physical presence on the disk.
>

>Thanks for the resposne. Could you please explain as to how the file could be created and not have a physical presence? I'm not really understanding that part.

Jon,

A file can be created with FILE_ATTRIBUTE_TEMPORARY in wich case Windows File systems avoid writing data back to the disk if sufficient cache memory is available, because often the application deletes the temporary file shortly after the handle is closed. In that case, the system can entirely avoid writing the data. Otherwise, the data will be written after the handle is closed.