Very slow access on table cause sql is messed up
Hello,
and sorry if this post is started in the wrong community, but i find nothing thats fits more.
We have ported a table from ms access to oracle via oracles sql developer,
and all operations are very slow on this table so we take a look at the generated sql.
If we send following simple sql:
SELECT * FROM "DB_RECHNUNG"."AUFTRÄGE_HK3_VERRECHNUNGSPREIS"
v$sqltext shows following executed sql:
and sorry if this post is started in the wrong community, but i find nothing thats fits more.
We have ported a table from ms access to oracle via oracles sql developer,
and all operations are very slow on this table so we take a look at the generated sql.
If we send following simple sql:
SELECT * FROM "DB_RECHNUNG"."AUFTRÄGE_HK3_VERRECHNUNGSPREIS"
v$sqltext shows following executed sql:
SELECT
"FIRMA","RDATUM_ALT","RDATUM","JJJJMM","DOKART","RNR",
"KAPITEL","POSITION","POSITIONINTERN","AART_ALT","AART",
"VART","DEBIGRP_ALT","DEBIGRP","KUNDE_ALT","KUNDE",
"SABE","LAND_ALT","LAND","POSTADRESSE","VERSANDADRESSE",
"RECHNUNGSADRESSE","KUNDENGRUPPE_ALT","KUNDENGRUPPE",
0