I have a set of tables I'm describing with DBIx::Class, then deploying to MySQL (or Postgresql, depending on the customer's whim). This works nicely.

Now I have a problem: for performance reasons, I'd like to add indexes to some columns. The problem is, some of those columns are not uniqe,
so add_unique_constraint is not useful for the purpose.

I've gone through the man pages, but I can't seem to find any way to add indexes that aren't either foreign keys, or unique, or both.

Any pointers would be welcome....

_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/

Reply via email to