Is there a misterious way to know if other users has records in a temporary table?

From: Juan Carlos Reyes Pacheco <>
Date: Tue, 16 Jun 2015 11:48:16 -0400
Message-ID: <>

The reason is because I want to cache in standard edition the results of some procedures, for performance.

but if I modify the source tables, I need to invalidate that values, this means

procedure test

 (*)validate the source data was not modified.

  select from memory result for procedure test.

 when no data_found

    obtaing test result
   insert into memory result.


Received on Tue Jun 16 2015 - 17:48:16 CEST

Original text of this message