Re: Should I Index?
From: Peter Yeoh (nospam_at_nospam.com)
Date: 06/03/04
- Next message: John Bandettini: "RE: Should I Index?"
- Previous message: Uri Dimant: "Re: Index Question"
- In reply to: Keith: "Should I Index?"
- Next in thread: John Bandettini: "RE: Should I Index?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Jun 2004 18:40:52 +0800
They need indexes to be created explicitly, unless they are the primary keys
for their respective tables. AFAIK, Interbase/Firebird is one database that
automatically creates indexes for foreign key references.
Peter Yeoh
http://www.yohz.com
Need smaller backup files? Try MiniSQLBackup
"Keith" <@.> wrote in message news:ufaQPVVSEHA.3932@TK2MSFTNGP10.phx.gbl...
> I have a series of many-to-many relationships, so obviously have a number
of
> 'join' tables. These join tables store only the unique key from the other
> tables.
>
> Is there any advantage to indexing the fields in the join tables or is it
> not necessary because the data in them is technically indexed in another
> table or do they still need indexing in their own right?
>
> Thanks
>
>
- Next message: John Bandettini: "RE: Should I Index?"
- Previous message: Uri Dimant: "Re: Index Question"
- In reply to: Keith: "Should I Index?"
- Next in thread: John Bandettini: "RE: Should I Index?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
