how can I check if a index is needed to be rebuild or not?

From: Cantonese Boy <cantoneseboy_at_netscape.net>
Date: Thu, 28 Dec 2000 00:21:58 +0800
Message-ID: <3A4A1726.219EE6A7@netscape.net>

As title, if my index is always has one extent, how can I know when there is a need to rebuild the index? I know that there may be some "holes" inside the index that will cause performance problem, how can I know?

Thanks

W Received on Wed Dec 27 2000 - 10:21:58 CST

This message: [ Message body ]
Next message: Mike Krolewski: "Re: how can I check if a index is needed to be rebuild or not?"
Previous message: Mike Krolewski: "Re: Problem with Oracle float type"
Next in thread: Mike Krolewski: "Re: how can I check if a index is needed to be rebuild or not?"
Reply: Mike Krolewski: "Re: how can I check if a index is needed to be rebuild or not?"
Reply: Sybrand Bakker: "Re: how can I check if a index is needed to be rebuild or not?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US