On Monday, March 18, 2002, at 03:40 PM, Jennifer Downey wrote:
> Just wondering, does a table have to have an index? If so what should I
> consider when making a colum an index?
You're not required to have an index, as far as I know. It's just that
an index is a way of optimizing retrievals
I have seen this problem before and, yes, an index field with
autoincrement is always a good thing to have.
Perhaps, this is not necessary, but usually works.
John
On Mon, 18 Mar 2002, Jennifer Downey wrote:
>-Hi all,
>-
>-Just wondering, does a table have to have an index? If so what should I
You don't have to have an index in order for an update to work, although indexes do
help performance a great deal when you are dealing with a lot of records. Do you have
"Update" permissions on the particular table/database you are working with?
Brian Drexler
-Original Message-
F
3 matches
Mail list logo
