Re: Problems with SELECT *

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 14 Mar 2003 11:03:37 -0600
Message-ID: <Xns933E66570C586pingottpingottbah@216.166.71.233>

cimarron+google_at_taylors.org (Cimarron Taylor) wrote in news:29e28c51.0303131009.10514345_at_posting.google.com:

> Not if the system is column-oriented or if the table uses
> a "Vertical Partitioning" scheme.

I've yet to see someone design a system where you have _one_ column per table and those tables are coalesced to produce the result set -- imagine how poor the performance would be otherwise!

When veritical partitioning is employed, it's usually to group like columns.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Fri Mar 14 2003 - 11:03:37 CST