BLOG|TOAD

Listing Page

Quest Software hero - {archive_type} Listing Page
Table Join Syntax
Table Join Syntax

Table Join Syntax

This tip covers how to specify the table join syntax which is used when SQL alternatives are generated. When the syntax for SQL statements was originally developed, the conditions of joining tables w...

Rearranging the Driving Path
Rearranging the Driving Path

Rearranging the Driving Path

This tip covers the importance of finding the best “driving path” for retrieving rows from the database. We’ll use a simple illustration of a Nested Loop operation that retrieves data accessing 2 tab...