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/