> -----Original Message-----
> From: Stephen Gutknecht (SAPDB) [mailto:IML-sapdb@stripped]
> Sent: Sonntag, 18. August 2002 19:26
> To: Matthias Reich; SAP DB General List
> Subject: RE: "info state" command shows Bad Indexes
>
>
> Is there any way to determine WHICH indexes are bad? Some of
> my indexes
> take over 1 hour to re-create...
>
> Thank you.
>
> Stephen Gutknecht
> currently in Renton, Washington USA
>
Try a
SELECT * FROM DOMAIN.SHOW_BAD_INDEX
Elke
SAP Labs Berlin
> -----Original Message-----
> From: Matthias Reich [mailto:rei@stripped]
> Sent: Wednesday, July 31, 2002 6:04 AM
> To: Stephen Gutknecht (SAPDB); SAP DB General List
> Subject: Re: "info state" command shows Bad Indexes
>
>
> Am Mittwoch, 31. Juli 2002 14:28 schrieb Stephen Gutknecht (SAPDB):
> > Hi,
> >
> > The output of "DBMCLI -c info state" command shows "Bad Indexes =
> > ******".
> >
> > Anything I should be worried about?
> >
> > Thank you.
>
> you should SAPDB let recreate the Bad Indexes.
>
> WebDBM/DBMgui -->Recovery-->Index
> or dbmcli:
> dbmcli -d DATABASE -u user,pwd sql_recreateindex
>
> I guess
>
> HIH
> -m
> --
> HAGOS eG phone: +49 711 7880592
> Matthias Reich fax: +49 711 7880599
> Industriestr. 62 web: http://www.hagos.de
> D-70565 Stuttgart mail: rei@stripped
> Germany
> _______________________________________________
> sapdb.general mailing list
> sapdb.general@stripped
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
