| Subject | Re: How to optimize view to work faster |
|---|---|
| Author | Sasa Mihajlovic |
| Post date | 2007-12-09T23:17:50Z |
Here is a list of indices:
robfaktura (header table)
ID: primary key (PK_ROBFAKTURA)
robfakturas (items table)
ID: primary key (PK_ROBFAKTURAS)
ROBFAKTURA: forign key on robfaktura table (FK_ROBFAKTURAS_1)
there is no other keys on both tables
robfaktura (header table)
ID: primary key (PK_ROBFAKTURA)
robfakturas (items table)
ID: primary key (PK_ROBFAKTURAS)
ROBFAKTURA: forign key on robfaktura table (FK_ROBFAKTURAS_1)
there is no other keys on both tables