I am having some "drinking from the firehose" moments where situation dictates I have to learn some things quickly and have limited tolerance for error. Hopefully, I can state my question succinctly and someone will be willing to offer advice.

I ran the DBCC scan on the DB and with some of the larger tables (500,000+ records) it was reporting over 70,000 pages with extent fragmentation in excess of 30% and logical fragmentation in excess of 40%. My understanding is this is a DB badly in need of defrag. (Side note, my understanding is that an earlier rev siilarly used would "in explicably become inaccessible and it looked like it was the tempdb" was the explanation)

Would your recommendation be to:

1) defrag with something like DK and then use REINDEX

2) RECREATE the indexes

3) something else? (to my limited understanding DEFRAG would not be a best candidate in this case)

Hopefully I have offered enough information to hazard an opinion.