Copy & Paste (Recreate) collection indexes
We have a lot of experimntal work with our databases and I found myself constantnly trying out new indexes and performance improvements. What could save me a TON of time (I manually create 20-30 indexes per day when I'm working on them) is the simple option to:
- Right click on collection -> Copy Index(es)
- Right click on target collection -> Paste index(es) 2a. If an index with the same name exists overwrite them
I know I can use mongodump and restore the indexes but like I said this isn't a db backup / restore scenario this is experimental work and it would take me a lot more time to dump the data & restore than to manually create indexes. A need for copying just the indexes is required here.
Thank you!
P.S.
Your great, Studio 3T is great, mongo is great, keep up the fantastic job!
Zoran Bogdanov
shared this idea
Hi, we improved this in 2021.4: https://studio3t.com/whats-new/release-2021-4/
We hope it makes your daily tasks a little easier!
-
Charles Lindsay
commented
This feature should already be included as we can copy/paste collections WITH indexes, now we just need an INDEX ONLY copy/paste functionality. This should be very low hanging fruit.