Re: Indexes and Stored Commands/Procedures

On 12 Sep 1996 01:49:06 GMT, sammers@pop03.ca.us.ibm.net (crunch) wrote: > >General question on indexes. > > IMHO tables (with indexes) that have high volumes of insert and >delete operations need to be re-index periodically, else 'bad' things >will happen. Please comment. Read the "SQLBase Advanced Topics Guide" which is shipped with SQLBase 6.1. There is detailed information about whats going on with indexes when inserting or deleting rows! > With some databases (e.g. SQLBase 5.x), stored commands/procedures >need to be dropped and re-stored if you re-index a table. What are the >exceptions, if any? There are no exceptions for SQLBase becouse the thing that is stored for a "stored command " is the execution plan which tells the database enginge which indexes to use - therefore if there is a new index created after storing the command the stored execution plan is not changed and the new index - even if it is better - would not be used! > I would appreciate any information on these subjects whether in >support or in contradiction of what I believe to be true. I have been >unsuccessful in trying to dig up literature that provides explicit >information on these matters which I need to build a case upon. Some of the >folks I work believe that re-indexing is strictly an option, not a >necessity and I have no way of proving otherwise. > Thanks much. > > >Joe Yong >Software Alliance (M) Sdn. Bhd. Hope my comments where helpfully for you Martin Knopp Pict & Byte