You know you are using the proper file editor when such a basic task as Index break accredetation does not take more time than it should. Editing files is now a part of many working operations in numerous professional areas, which is the reason accessibility and simplicity are essential for editing instruments. If you find yourself studying guides or trying to find tips on how to Index break accredetation, you may want to get a more easy-to-use solution to save your time on theoretical learning. And this is where DocHub shines. No training is required. Simply open the editor, which will guide you through its principal functions and features.
A workflow becomes smoother with DocHub. Make use of this instrument to complete the files you need in short time and take your efficiency to another level!
why would dropping an index make a view invalid and thats a very interesting question [Music] views and indexes we have a very large pl sql code base that was mysteriously having issues with large invalidations recompilations as in we all know that when you drop a table anything thats referring to that table like pl sql triggers etc get invalidated but they had views we tracked it down to when we dropped an index some views on the table with the dropped index then became marked invalid and things cascaded from there why would dropping an index make a view invalid and thats a very interesting question its actually a friend of mine named jock who posed this via an email funnily enough its actually in the documentation the docs actually say if you drop indexes then views may become invalid but doesnt explain why and so this led to a bit of investigation as to why were dropping an index on a view by dropping the extra table make your view on that table going valid because the view