Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

Or are the two basically the same when it comes to figuring out how to build the right indexes?

share|improve this question

closed as not constructive by ChrisF Jan 20 '12 at 11:46

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

up vote 1 down vote accepted

MySQL's one better for MySQL and Postgres' one is better for Postgres.

Both databases' internals differ a lot, so the outputs of their respective EXPLAINs are constructed in a way that tells most about how each of them deals with given query.

share|improve this answer
I'll buy that.. –  Robert Harvey Jun 26 '11 at 19:01
That'll be €22, thank you. ;) –  Mchl Jun 26 '11 at 21:43

Not the answer you're looking for? Browse other questions tagged or ask your own question.