Timeline for What is a "Partial Matching Index"?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 15, 2017 at 22:28 | comment | added | RolandoMySQLDBA |
You could ditch create unique index FULL_IX_UNIQUE ON FK_PARENT_TABLE (FKey, Fkey2, Fkey3), keep the index on FKey2 and try again.
|
|
| Dec 15, 2017 at 22:25 | comment | added | Joe Obbish | I understand and appreciate any ideas to try. I also can't get the two column one to work. | |
| Dec 15, 2017 at 22:22 | comment | added | RolandoMySQLDBA | Please remember I am not a SQL Server guy, but I am just trying to help. | |
| Dec 15, 2017 at 22:20 | comment | added | RolandoMySQLDBA |
Not exactly. Try making a FK with (FKey2,FKey3) and create an index on FKey2. Please try that.
|
|
| Dec 15, 2017 at 22:10 | comment | added | Joe Obbish | Is this what you had in mind? Still can't get it to work... dbfiddle.uk/… | |
| Dec 15, 2017 at 20:39 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |