I noticed today that some of my queries are not going into the SQL Recall history. I have a big query that I wanted to save as a named query when I noticed that it wasn’t listed in the history at all, even though I had just successfully run it. I then tried SELECT * FROM dual and it went right in the history. Tried my query again, it ran, but still would not be saved in the history.
What might I look for to figure out why every query is not automatically saved. I am hesitant to posting the code here because of business sensitivity and it is quite large. Certainly it isn’t size-related (whether or not to save the query depends on the size???)
I am using Toad Data Point 126.96.36.1996