Then you can pre-join in a view to get the faster speed. ( view is the
SQL Server term, In Access I think you can use "queries" like views, I
believe Oracle has a similar feature).
At 11:04 AM 7/19/2004, you wrote:
>Lets say that a join has to be made between 4 or 5 different tables.
>Two or three of these tables can be avoided by creating a column or
>two in one table. These columns will usually be blank. Is it better to
>have more, tighter tables and join them or to make fewer tables with
>more columns even if one of those columns may not have much data?
>Not worrying about space, just speed.
>Let the debate begin. :)
>
>--
>Michael Dinowitz
>http://www.houseoffusion.com
>For all your ColdFusion needs
--
Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer
<mailto:[EMAIL PROTECTED]>
--
AIM: Reboog711 | Phone: 1-203-379-0773
--
My Books: <http://www.instantcoldfusion.com>
Recording Music: <http://www.fcfstudios.com>
Original Energetic Acoustic Rock: <http://www.farcryfly.com>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
