Re: Sequential scan and lock on small tables

Posted in 2004

rkusenet — Sat, 17 Apr 2004 08:19:45 -0400 — source: Usenet: comp.databases.informix

"Five Cats" <cats_spam@[127.0.0.1]> wrote > Is the lock mode for the table row or page? If it's page (and it's like > the UNIX versions1) locking one row will lock all the other rows on the > same page. > > of course this may be total tripe given it's on NT. I think Informix engine has some sort of algorithm that if all the rows of a table fits in one page, then use only sequential scan. Given that on NT, an Informix page is 4K, this small table ttt would not fit into more than one page, unless it has few hundred rows.