Re: Denormalization
- From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
- Date: 1 Jul 2006 00:46:26 -0700
stephanwehner@xxxxxxxxx wrote:
Hi Bill,
Thanks for the link.
I take it then that is not out-of-the-ordinary to split a table in this
manner.
I was trying to understand how this is dealt with in other database
engines as well. Views don't allow this kind of optimization?
Stephan
It's a technique common to DBMSs that don't have better optimization
features. Most enterprise DBMSs do allow physical partitioning without
creating new tables. In those systems that don't you may be forced to
create new tables ("logical partitioning") as a workaround. I don't
know MySQL so I don't know if it has better ways to do this.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
.
- References:
- Re: Denormalization
- From: Bill Karwin
- Re: Denormalization
- From: stephanwehner
- Re: Denormalization
- Prev by Date: Re: Denormalization
- Next by Date: Re: I think that relational DBs are dead. See link to my article inside
- Previous by thread: Re: Denormalization
- Next by thread: Re: Denormalization
- Index(es):
Relevant Pages
|
