Hi, rebuild index need when index in status invalid (check status in all_indexes) and create index need when you don't have index in your table and that table is big and always use in query.
________________________________ From: Moch Firman N <[email protected]> To: [email protected] Sent: Mon, October 12, 2009 11:52:40 AM Subject: [indo-oracle] Index Rebuilding vs Index Recreating Dear All, Any one knows when we should rebuild the index? And when we should recreate the index? What is the actual parameter of those ? Thanks and best regards Piping [Non-text portions of this message have been removed] __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
