Comparing bookmark and query history features
In Chapter 11, we learned about the SQL history feature, which automatically stores queries (temporarily or permanently). There are similarities between queries stored in the history and bookmarks. After all both features are intended to store queries for later execution. However, there are important differences regarding the way the queries are stored and the action that triggers the recording of a query.
Storing of queries in the history is automatic; whereas a query is saved as a bookmark via an explicit request from the user. Also, there is a configurable limit (refer to Chapter 11) on the number of queries stored in the permanent history; however, the number of bookmarks is not limited. Finally, the history feature presents the queries in the reverse order of the time they were sent. However, bookmarks are shown by label (not showing the query text directly).
To summarize, the automatic query history is useful when we neither plan to recall...
