Claude Schneegans wrote: >> You had to lock a table to index it? That is soo 80'ies > > Yeah, after 25 years, the only difference is that the lock is handled > automatically by the database engine. > Not a big deal ;-)
In a current database you can continue to insert, update and delete while you create an index. And when you can not afford to take the database offline for a few hours that is a big deal. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
