Re: 23,000 Tables?

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Thu, 16 Nov 2006 03:16:14 GMT
Message-Id: <pan.2006.11.16.03.16.14.781459@gmail.com>

On Wed, 15 Nov 2006 17:33:42 -0800, cd2448 wrote:

> i would love to. but we don't have the option to normalize the tables,
> which would be the real best practice approach, because we must have
> all fields in one table for a given report. i agree that there are

What is wrong with having normalized tables and placing views on top of the tables to satisfy the reports constraints?

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Wed Nov 15 2006 - 21:16:14 CST