Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

14. Using Query Bookmarks > Comparing bookmark and query history features

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).


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint