В первую очередь хочу сказать, что очень нравится среда и использовать ее большое удовольствие. Все грамотно и удобно. Но.
Есть проблема с открытием некоторых запросов. Среда виснет, как мне кажется, при парсинге текста запроса. Причем не важно есть подключение к БД или нет. Достаточно начать править или переместить курсор по тексту чтобы погрузить среду в глубокую думу (одно ядро почти полностью загружено).
Пример запроса:
Код: Выделить всё
with
subject as
(select /*+ materialize */ * from fdc_nsi_subject_v s ),
official as
(select /*+ materialize */ * from fdc_nsi_sbj_official_v)
select deed.id
,deed.no
,deed.no_full
,deed.cause_complete_id
,cc.name as cause_complete_name
,deed.okrug_id
,okr.name as okrug_name
,okr.short_name as okrug_short_name
,okr.notation_mgi as okrug_notation_mgi
,deed.employee_id
,se.name as employee_name
,se.short_name as employee_short_name
,se.position_name as employee_position_name
,deed.creator_id
,sc.name as creator_name
,sc.short_name as creator_short_name
,sc.position_name as creator_position_name
,sc.organization_short_name as creator_org_name
,deed.author_id
,sa.name as author_name
,sa.short_name as author_short_name
,sa.position_name as author_position_name
,deed.represent_id
,sp.name as represent_name
,sp.short_name as represent_short_name
,deed.division_id
,sd.name as division_name
,sd.short_name as division_short_name
,sd.code division_code
,sd.code_name division_code_name
,deed.notified_person_id
,sd.name as notified_person_name
,sd.short_name as notified_person_short_name
,deed.copy_receipient_id
,scr.name as copy_receipient_name
,scr.short_name as copy_receipient_short_name
,deed.status_id
,ds.name as status_name
,deed.value_date
,deed.protocol_date
,deed.last_change
,deed.kpk_flag
,deed.offence_datetime
,deed.protocol_familiar
,deed.signature_rejection
,deed.delivery_date
,deed.post_receipt_no
,deed.offence_consist
,deed.violator_reasoning
,deed.consid_participate_rej
,deed.representative_flag
,deed.representative
,deed.violator_person_id
,svp.name as violator_person_name
,svp.short_name as violator_person_short_name
,svp.position_id as violator_person_position_id
,svp.position_name as violator_person_position_name
,svp.organization_id as violator_org_id
,svp.division_id as violator_person_division_id
,svp.ogrn as violator_person_ogrn
,svp.inn as violator_person_inn
,svp.kpp as violator_person_kpp
,svp.address_reg as violator_person_address_reg
,svp.address_fact as violator_person_address_fact
,svp.date_birth as violator_person_date_birth
,svp.type_id as violator_person_type_id
,svp.type_short_name as violator_person_type_sname
,svp.date_reg as violator_date_reg
,deed.violator_type_id
,vt.name as violator_type_name
,vt.short_name as violator_type_short_name
,deed.is_violator_present
,deed.status_fdate
,deed.decision_id
,dmd.name as decision_name
,deed.decision_registry_id
,deed.trans_reestr_id
,deed.decision_reg_sort
,deed.make_address_id
,deed.parent_id
,deed.income_date
,deed.income_no
,deed.type_id
,dt.name as type_name
,deed.send_via_post
,deed.submit_personaly_date
from fdc_deed deed, fdc_rd_cause_complete cc, fdc_rd_deed_type dt, fdc_nsi_bti_okrug_v okr, official se, official sc, official sa, fdc_nsi_sbj_division_v sd,
subject sn, subject scr, fdc_rd_deed_status ds, fdc_rd_violator_type vt, subject sp, fdc_rd_deed_meet_decision dmd
where
deed.cause_complete_id = cc.id(+)
and fdc_rd_deed_type dt on dt.id = deed.type_id
and fdc_nsi_bti_okrug_v okr on okr.id = deed.okrug_id
and se.id = deed.employee_id
and sc.id = deed.creator_id
and sa.id = deed.author_id
and sd.id = deed.division_id
and sn.id(+) = deed.notified_person_id
and scr.id(+) = deed.copy_receipient_id
and deed.status_id = ds.id
and svp.id = deed.violator_person_id
and deed.violator_type_id = vt.id
and sp.id(+) = deed.represent_id
and deed.decision_id = dmd.id(+)
from fdc_deed deed
left join fdc_rd_cause_complete cc
on deed.cause_complete_id = cc.id
inner join fdc_rd_deed_type dt on dt.id = deed.type_id
inner join fdc_nsi_bti_okrug_v okr on okr.id = deed.okrug_id
inner join official se on se.id = deed.employee_id
inner join official sc on sc.id = deed.creator_id
inner join official sa on sa.id = deed.author_id
inner join fdc_nsi_sbj_division_v sd on sd.id = deed.division_id
left join subject sn on sn.id = deed.notified_person_id
left join subject scr on scr.id = deed.copy_receipient_id
inner join fdc_rd_deed_status ds on deed.status_id = ds.id
inner join subject svp
on svp.id = deed.violator_person_id
inner join fdc_rd_violator_type vt on deed.violator_type_id = vt.id
left join subject sp on sp.id = deed.represent_id
left join fdc_rd_deed_meet_decision dmd
on deed.decision_id = dmd.id