Re: Indexes not being used?

[David Wynter]

Table u SHOW INDEXES FROM output

'u', 0, 'PRIMARY', 1, 'S_ID', 'A', 839352, , '', '', 'BTREE', ''
'u', 1, 'IX_UL', 1, 'UL_ID', 'A', 17, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_S_TYPE', 1, 'S_TYPE', 'A', 474, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_BCINFO', 1, 'BC_ID', 'A', 419676, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_R1', 1, 'R1', 'A', 839352, , '', 'YES', 'BTREE', ''
'u', 1, 'FK_IND_RIC', 1, 'IND_RIC', 'A', 17, , '', 'YES', 'BTREE', ''
'u', 1, 'FK_FND_RIC', 1, 'FND_RIC', 'A', 17, , '', 'YES', 'BTREE', ''
'u', 1, 'FK_OPT_RIC', 1, 'OPT_RIC', 'A', 17, , '', 'YES', 'BTREE', ''
'u', 1, 'W_XREF', 1, 'WX', 'A', 839352, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_C1', 1, 'C1', 'A', 17, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_S1', 1, 'S1', 'A', 839352, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_V1', 1, 'V1', 'A', 69946, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_I1', 1, 'I1', 'A', 839352, , '', 'YES', 'BTREE', ''
'u', 1, 'IX_I1', 2, 'E1', 'A', 839352, , '', 'YES', 'BTREE', ''

Table cw SHOW INDEXES FROM output

'cw', 0, 'PRIMARY', 1, 'Id', 'A', 1879, , '', '', 'BTREE', ''
'cw', 1, 'FK_cw_1', 1, 'Portfolio_Id', 'A', 2, , '', '', 'BTREE', ''

Hey, I ordered your book, it arrives on the 22nd December, maybe I won't have to ask so many questions after I have read it ;)

Thx,

David