subqueries

The queries were complex, involving combinations of self-joins, temporary tables, time functions, and subqueries that were often ludicrous, and my forehead sometimes throbbed as I tried to work out the methods involved, but as far as I could tell they'd do the trick.

The Mini-Movie Reviews: March 2006

Macros make it possible to build a domain-specific set of subqueries on top of the StreamInsight LINQ language, so that defining computations and analytics becomes more accessible and straightforward.

Site Home The StreamInsight Team 2011

Correlated subqueries are a usability nightmare, and the check-list demand for ACID compliance -- transactional atomicity, consistency, isolation, durability -- is simply overhead overkill for analytical applications.

Intelligent Enterprise 2010

You don't have to select from just tables, you can select from joins, subqueries, and unions.

Softpedia - Windows - All Softpedia Linux 2010

The January 2010 meetup will go over how to write optimal joins and subqueries.

developerFusion - content James Crowley 2010

Do not use correlated subqueries on anything that needs to go fast.

ASP.NET Forums joeastral 2010

You can use subqueries today in InfiniDB by setting our vtable mode to pass everything to MySQL, but trust me: you don't really want to send subqueries against TB's of data and billions of rows directly to MySQL for processing unless you plan on waiting a while for your response.

Planet MySQL Robin Schumacher 2010

You don't have to select from just tables, you can select from joins, subqueries, and unions.

Softpedia - Windows - All Softpedia Linux 2010

Because we technically do have subqueries now, the addition of high-speed subqueries would qualify for a MINOR number bump.

Planet MySQL Robin Schumacher 2010

I generally recommend that customers NOT use UDFs in cases where plan choice is important to their system (ie big queries) and to specifically not put subqueries inside of UDFs.

Site Home 2010