| Indexing [message #64299] |
Mon, 10 January 2005 17:55  |
devika
Messages: 21
Registered: November 2004
|
Junior Member |
|
|
|
What is the difference between index rebuild and index recreate ??
|
|
|
|
| Re: Indexing [message #64313 is a reply to message #64299] |
Tue, 11 January 2005 03:43  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
Rebuild is 1 command (ALTER). Recreate is 2 commands (DROP + CREATE).
More seriously, rebuild is easier to use and can be done on-line while users are working (well, mostly).
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
