| Subject | RE: [firebird-support] Possible to have an index across 2 tables? |
|---|---|
| Author | Maya Opperman |
| Post date | 2008-11-04T10:15:52Z |
Mimmo Wrote:
is..
>Seems to me, from count of Records, that there are 1:N relationships. NCorrect
>incident and 1 customer, N Comm and 1 incident.
>Incidents.CustomerID and Comms.IncidentID are not UNIQUE indexes as you
>initially supposed.
>Anyway, comms records can't get confused by customer.Yip, going to try Helen's statement anyway, and see what the performance
is..