#5568: [patch] DROP INDEX subcommand
-----------------------+----------------------------------------------------
Reporter: p | Owner: nobody
Status: new | Component: django-admin.py
Version: SVN | Keywords: management sql indexes drop index
Stage: Unreviewed | Has_patch: 1
-----------------------+----------------------------------------------------
Attached is a patch for a subcommand of django-admin.py that prints DROP
INDEX SQL statements for a given app, as in:
{{{
$ django-admin.py sqldropindexes my_app
BEGIN;
DROP INDEX my_app_people_name;
DROP INDEX my_app_people_email;
COMMIT;
}}}
This is useful for speeding up a big INSERT. Indexes can then be rebuilt
with {{{django-admin.py sqlindexes my_app}}}.
--
Ticket URL: <http://code.djangoproject.com/ticket/5568>
Django Code <http://code.djangoproject.com/>
The web framework for perfectionists with deadlines
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---