Start with in Oracle. How to optimize connect by prior

start with in Oracle. How to optimize connect by prior?
an address table has a total of 8-level addresses. Pass in the address id, to query all the superior addresses. The code is

select address_id    addressId,
           address_name  addressName,
           address_level addressLevel
          from rm_address t
             start with t.address_id = -sharpvillageId-sharp
            connect by t.address_id = PRIOR t.PARENT_ADDRESS_ID
             order by address_level

now the query is very slow, how to optimize it? -sharp-sharp title text-sharp-sharp

Oracle sql

Jan.08,2022

for this kind of problem, it is recommended to talk about the amount of data in the table, the index, as well as the current execution time and execution plan of the sql statement, so as to facilitate everyone to analyze the problem.

according to the sql statement you wrote, please first check whether there is an index on the t.address_id field.

Previous: If the exec in child_process ends the reg.exe process

Next: -how to write the sharpifndef header file?

What is stored in the database is the html code, how to blur the contents of the query tag?
what is stored in the database is the html code, which is mainly a piece of div content, including the style, does not contain the body and other tags, and the label is strict in opening and closing. If I want to query the keyword "class " now, if I us...

Oracle sqlserver mysql java php

Mar.03,2021
The usage of as in sql query statement;
is currently self-learning mysql,. When querying, sometimes you need to use as aliases, but after adding as aliases to the following two query statements, why is it incorrect? 1, select cat_id,goods_name,shop_price from goods where shop_price in (sele...

Oracle sql mysql

Mar.05,2021
An Analysis of the Business scenario of Synchronize
The business scenario is as follows: I provide a ws server A for client B to call. Each call, the client inserts a piece of data into the database tab and then submits it. My server An internally calls another server C, and passes this data to the serve...

Webservice oracle sql

Mar.05,2021
Date-time format conversion of Python connecting to Oracle database through cx_Oracle?
1. Process: Python looks up the data in the table through cx_Oracle and inserts the data into another table. 2. The type of date and time stored in both tables is of type Date. 3. The time field I took from the query table prints out that the type i...

Python oracle sqlserver

Mar.06,2021
Perform a second screening from the result set
as shown in the figure, this association query is different in that it is associated with the same table indicates that table_test requirement: first query the result set of the field whose reply_type is 0, and then use the reply_id of the resul...

Nosql oracle sql mysql

Mar.07,2021
Multiple tables query the last 100 pieces of data?
how do I query the last 100 pieces of data in multiple tables in the ORACLE database? For example, the two tables of An and B have a time field, and the last 100 items of data in tables An and B are not the last 100 items in An and B. ...

Oracle sql

Mar.07,2021
Count () sorting problem of oracle Database
I want to sort each person s type in descending order according to the sum of the sl of each person s sl. What should I do with ...

Oracle sql java

Mar.13,2021
Multiple left join optimizations
< H2 > tables: < H2 > employee employee_orgn: federated primary key (employee_id,orgn_id), index 1, 2:orgn_id employees, index orgn < H2 > sql: < H2 > explain SELECT DISTINCT e.* FROM employee e LEFT JOIN employee_orgn eo ...

Java oracle sql mysql

Mar.31,2021
Is the principle of mysql multi-database and multi-table joint check is Synchronize double writing?
problem description is the principle of mysql multi-database and multi-table joint query based on Synchronize double writing? the platform version of the problem and what methods you have tried try to find it in books such as mysql performance opt...

Oracle sql mysql

Apr.02,2021
In the oracle view, take the sum of the same field value
wrote an attempt in oracle. I want to add a field to get the QTYGOOD and of the same RD.SKU line. CREATE OR REPLACE VIEW aaa AS SELECT R.WHSEID, RD.STORERKEY, RD.SKU, CASE WHEN LOC.LOCATIONCATEGORY <> NG AND RD.COND...

Oracle sql sql-statement

May.02,2021
How to realize multi-table union search?
the structure of the table is as follows: now I need to query the contents from different tables according to the user s input. How can I quickly and effectively find out the results I want? my idea is to associate the three tables, use case.whe...

Mysql sql oracle sqlserver postgresql

May.06,2021
The problem of replacing sqlServer database with oracle database in SSH framework
Environment: Spring3 SpringMvc Hiberate4 SqlServer2005 Oracle11g now it s time to replace the sqlServer database with the oracle database. After changing the database configuration, the project can start normally, but an error will be reported as soo...

Oracle sqlserver hibernate spring-mvc spring

Aug.19,2021
In general, what do you simply consider when you add an index? Why do I need an index of 2 fields?
what do you usually consider when adding an index? I usually add an index by querying a few fields in the where clause and adding an index to those fields. ...

Sqlserver postgresql oracle sql mysql

Jan.08,2022