The process by which SQL Server anticipates which pages a session will require, and reads them into the Buffer Cache before they are requested by the user connection. Used when SQL Server determines that a session is accessing table or index pages in a sequential manner. If the sequential processing does indeed continue, these pages will already be in the cache memory when required, thereby avoiding the need to wait for an I/O operation.
Referential Integrity ensures that foreign keys correctly map to primary keys. A referential constraint prevents the insertion or update of foreign keys for which there are no matching primary keys, by either preventing the deletion of primary keys if foreign keys exist, or deleting these foreign rows (DELETE CASCADE).
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center