索引查询测试

select  b.org_code,b.field_id from T_DIAG_DETAIL_INDEX b where b.org_code is not null and b.field_id is not null;

select  b.org_code from T_DIAG_DETAIL_INDEX b where b.org_code is not null and b.table_cn_name='סԺҡи˗ҳ';

select  b.org_code,b.field_id from T_DIAG_DETAIL_INDEX b where b.org_code is not null and b.data_status='1';

select  b.org_code,b.field_id from T_DIAG_DETAIL_INDEX b where b.org_code is not null and b.field_id is not null and b.data_status='1';

select  b.org_code,b.field_id from T_DIAG_DETAIL_INDEX b where b.org_code is not null and b.field_id is not null;
select  b.org_code from T_DIAG_DETAIL_INDEX b where b.org_code is not null;
select  b.field_id from T_DIAG_DETAIL_INDEX b where b.field_id is not null;
select  b.field_id from T_DIAG_DETAIL_INDEX b;