Alban Hertroys <[EMAIL PROTECTED]> writes:
> G. Ralph Kuntz, MD wrote:
>> explain select file_name from encounter_properties_table where file_name not
>> in (select filename from xfiles);
> What about:
> explain select file_name from encounter_properties_table
> where not exists (
> select f
G. Ralph Kuntz, MD wrote:
What's happening here?
I have two tables, encounter_properties_table with about 10 rows and
xfiles with about 50 rows. The structures of these tables is as follows:
file_name | character varying(255) |
Table "public.xfiles"
Column
What's happening here?
I have two tables, encounter_properties_table with about 10 rows and
xfiles with about 50 rows. The structures of these tables is as follows:
Table "public.encounter_properties_table"
Column | Type | Modifiers
+-
