RE: Indexing : Rules of Thumb ?

From: "edna.shepherd" <edna.shepherd@ntlworld.com> > >I have "inherited" a database with around 500 tables and hundreds of >indexes. >The majority of the tables are tiny in database terms (<1000 rows) but >still >have indexes applied; some of these tables will never grow beyond their >current volume. > >The database is almost certainly over-indexed and probably inefficient. >Any Rules of Thumb - in terms of numbers of rows - for when an index >becomes >more efficient than scanning ? > >Many thanks, > John If the indexes are used for RI then there's not much you can do Paul Watson # WF Software Ltd # All answers are +44 1435 674629 # pure fantasy +44 1436 678693 # www.wfsoftware.com/informix #