| Subject | RE: [firebird-support] Another compound index question |
|---|---|
| Author | E. D. Epperson Jr |
| Post date | 2014-01-28T20:00:51Z |
SubscriberId and ProviderId have a foreign key on Subscriber(SubscriberId) which is a Primary key, integer.
In the query, they may be the same, but not necessarily.
Since this is a new project, I don't know what the row count is, but it should be (eventually) in the millions. The SubscriberId and ProviderId would be unique to less than 100 rows.
Yes, it will be a common search
--
Dixon Epperson