Re: does a table always need a PK?

From: Pablo Sanchez <>
Date: 23 Aug 2003 18:57:56 GMT
Message-ID: <Xns93E09838F811Fpingottpingottbah_at_192.168.1.1>

Paul <> wrote in

> Now, as I understand it, RDBMS's will look at the size of a table
> before scanning it to see if it's worthwhile using an index, and if
> the table is too small, it'll just perform a straigh scan anyway and
> not bother with the index, even if you've gone to the trouble of
> putting one in.

Aside what Venkat points out, the more complex the query (more tables in the join) it's possible that the above becomes grossly inefficient. In-memory table scans can be very costly when paired with (millions of) nested iterations.

Pablo Sanchez, Blueoak Database Engineering
Received on Sat Aug 23 2003 - 20:57:56 CEST

Original text of this message