Re: Serial Update error
Five Cats wrote: > > Read the WHERE clause. That is where the serial column is used, we > certainly do *not* update it's value. *reads....... oh - duhhhh > So in effect the answer is yes. Thought it might be... Thanks. Glad to be of service - even if just by accident :-) A serial field is a bewwwwdiful candidate for an index. I'd be hard-pressed to think of a reason not to have one. Even if "there aren't that many rows in the table" I wouldn't justify dropping the index for that reason. Indexes aren't just for performance, they are sometimes for logic too. Although an index on a tiny table is nominally "less efficient" - welllll, compare that loss of efficiency with the cost of any work on a huge table, with or without the help of indexes. -- I have a simple philosophy that gets me through life: Never buy cheap toilet paper. Learn to know what is important, and what is not important. - Replies directly to this message will go to an account that may not be checked for a week or two. For more timely e-mail response, use (only in an emergency) ahamm sanderson net au with all the usual punctuation.
"Andrew Hamm" <ahamm@mail.com> wrote in message news:bffdiq$9jc4q$1@ID-79573.news.uni-berlin.de... > Although an index on a tiny table is nominally "less efficient" - welllll, > compare that loss of efficiency with the cost of any work on a huge table, > with or without the help of indexes. > Any the fact that if a small tables turns into a large table a) the system handles it (oooo, can we spell "scales well" kids?) b) you do not have to go back and then try and index a large table (can we spell "no downtime" kids? You can bet this will happen somewhere on the system! > -- > I have a simple philosophy that gets me through life: Never buy cheap toilet > paper. Learn to know what is important, and what is not important. > - > Replies directly to this message will go to an account that may not be > checked for a week or two. For more timely e-mail response, use (only > in an emergency) ahamm sanderson net au with all the usual punctuation. > >