go to post Martin Weissenborn · Jan 5, 2023 Make the index that you wish to build unavailable to queries (READ access). This is done using SetMapSelectability(). This makes the index unavailable for use by the Query Optimizer. This operation should be performed both when rebuilding an existing index and when creating a new index. For example: WRITE $SYSTEM.SQL.SetMapSelectability("Sample.MyStudents","StudentNameIDX",0)
go to post Martin Weissenborn · Aug 26, 2021 Try %ignoreindices * perheps you have a problem with the indicesIf you get an result you must rebuild the indices. select vet.ID, svp.ID_PACIENTE, vet.conselho, vet.uf, vet.numConselho, vet.nome, svp.SEQ_SOLICITANTE, vet.numConselho , vlab.numConselho from %ignoreindices * RPE.Veterinario vet inner join RPE.VeterinarioLab vlab ON vet.conselho = vlab.conselho AND vet.numConselho = vlab.numConselho AND vet.uf = vlab.ufleft join MySevi.SolicitanteVeterinarioPaciente svp on svp.ID_VETERINARIO = vet.ID where svp.ID_PACIENTE in ('6408||284144||47633', '6408||284145||47634')
go to post Martin Weissenborn · Aug 26, 2021 With this query you can find the deletet columns. select List(name) as tIdsfrom %Dictionary.StorageDataValueDefinitionwhere parent [ 'Tablename||'and Value is null
