Re: optimization/indexing
Re: optimization/indexing
- Subject: Re: optimization/indexing
- From: Andrew Lindesay <email@hidden>
- Date: Wed, 17 Dec 2008 17:19:25 +1300
Is adding the index using frontbase manager something that can be
done after a table is populated? Or will I need to export and re-
import my data? Sorry, I'm far from a database expert.
...
Yes, you can add them after the fact. The only time you can't do
that is if it is an unique index and your data is not unique. But
you have bigger problems then...
Jeff - if you have really large quantities of data, don't forget that
it can be a fairly intensive activity for a table's attribute to be
indexed so if it is a large database, best try to do it during a low-
ebb in system activity.
cheers.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden