Re: Problems with SELECT *

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 14 Mar 2003 11:03:37 -0600
Message-ID: <Xns933E66570C586pingottpingottbah_at_216.166.71.233> (Cimarron Taylor) wrote in

> 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
Received on Fri Mar 14 2003 - 18:03:37 CET

Original text of this message