RE: Speed of query - And Indexes

2001-06-09 Thread Chris Bolt
> I've used a rule of thumb that I was told ages ago when working on other > databases that inserting records into a non-indexed table is faster > generally than inserting records into an identical but indexed table. Makes sense to me, since it has to update the indexes in the latter case. Howeve

Re: Speed of query - And Indexes

2001-06-08 Thread Gary Huntress
I've used a rule of thumb that I was told ages ago when working on other databases that inserting records into a non-indexed table is faster generally than inserting records into an identical but indexed table. I realize that this statement is probably an antiquated guideline.and I'd like to