(id(number(PK)), item_code(varchar), item_desc(varchar), 1_code(varchar), 1_desc(varchar), 2_code(varchar), 2_desc(varchar), 3_code(varchar), 3_desc(varchar), 4_code(varchar), 4_desc(varchar), 5_code(varchar), 5_desc(varchar));
id,item_code,item_desc
where 1_code=1_code_in; where 1_code=1_code_in and 2_code=2_code_in; where 1_code=1_code_in and 2_code=2_code_in and 3_code=3_code_in;
CREATE INDEX MyTable_Composite_IX ON MyTable ( 1_code ,2_code ,3_code ,4_code ,5_code );
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)