implicit index creation on foreign key addition

#21

Il 22/12/2009 10.44, Marco Mariani ha scritto:

Quote:

Coniglio Sgabbiato wrote:

So... what about Mysql? It is OT but now I'm curious about their
decision to make it automatic

Mysql is even worse in that regard, since its SQL optimizer is... a very
special kid, as some parents would say, it will use indexes even when
scans would be more appropriate.
Several explanations with tests and charts are given in "Refactoring SQL
Applications", which I recommend
(http://oreilly.com/catalog/9780596514976) where the authors compare
Oracle, MSSQL and Mysql.
Needless to say, Postgres behaves more like the first two.

Mysql has several issues I really don't like. Its "group by" behavior
simply shocked me. This is just another point against it. I cannot
understand why people choose it over PG. Perhaps built-in replication is
the only functionality Mysql has over PG.

#22

On Tue, 22 Dec 2009 08:35:52 +0000, Jasen Betts wrote:

Quote:

On 2009-12-21, Coniglio Sgabbiato <nobody (AT) nowhere (DOT) net> wrote:

So... what about Mysql? It is OT but now I'm curious about their
decision to make it automatic

it it seems like just more arbitrary mysql stuff.

That's why MySQL will be assimilated. The resistance is futile.

--
http://mgogala.byethost5.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

implicit index creation on foreign key addition

comp.databases.postgresql comp.databases.postgresql

Re: implicit index creation on foreign key addition - 12-22-2009 , 06:51 AM

Re: implicit index creation on foreign key addition - 12-22-2009 , 12:32 PM