On Sat, May 31, 2003 at 00:14:18 -0600, Dave E Martin XXIII <[EMAIL PROTECTED]> wrote: > version: 7.3.2 > > Currently this table has one row in it, where name is 15 unicode > characters long. It would seem that there would be no need for an index > on name. However, doing:
It probably has one visible row in it. If it can changed a lot, there may be lots of deleted tuples in a row. That would explain why an index scan speeds things up. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
