Re: Indexes are not working after restoring dump
> I did verify, the indexes are present.
You ight want to rebuild them.
> Simple queries work fine. What I noticed is, its failing when using sub queries.
If that behaviour differs from what you saw before the deletion & restore, something about the restore failed. Otherwise as Øystein says, you'd do well to upgrade to 5.7.
Subject
Views
Written By
Posted
1563
September 27, 2018 11:25AM
901
September 27, 2018 01:39PM
720
September 27, 2018 01:45PM
771
September 28, 2018 12:21AM
723
September 27, 2018 07:14PM
674
September 27, 2018 08:31PM
Re: Indexes are not working after restoring dump
669
September 28, 2018 11:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.