MySQL Performance: MySQL => JOIN issue

Members

Help

Home

Home » Performance » MySQL » JOIN issue

Show: Today's Messages :: Show Polls :: Message Navigator

JOIN issue [message #453]

Wed, 06 December 2006 03:18

migandhi
Messages: 9
Registered: December 2006

Junior Member

is the join that may be LEFT OUTER or RIGHT OUTER or INNER or just JOIN the same as in MSSQL .
i am particularly interested in LEFT OUTER JOIN .

And i dont dare to use GROUP BY or DISTINCT as the query takes too long in execution.

My issue is proper migration from MSSQL to MySQL , which is becoming difficult at each step.

Report message to a moderator

[Message index]

Read Message JOIN issue
By: migandhi on Wed, 06 December 2006 03:18

Re: JOIN issue
By: Peter on Wed, 06 December 2006 06:59

Previous Topic: changing innodb_buffer_pool_size dynamically

Next Topic: JOIN optimization

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 02:31:39 EDT 2009

Total time taken to generate the page: 0.02165 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.