> Making the MySQL indexes would be your responsibility. Importing the data
> would most likely not import the index definitions also. You need to
> recreate those. Your explain seems to indicate that you have *no* indexes
> your table. I would guess that your query doesn't hang it just takes a
> long time to return.
I'm not a MySQL hacker, but...
> > Joshua, maybe there are some ineficient indexes, I don't know, because
> > the MSSQL database was not made by me. Iam just trying to migrate the
> > database to MYSQL and check that everything works fine.
> > My query is
> > "SELECT * FROM postulantes LIMIT 1,30"
Why should this query use any indices?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL