Shulou(Shulou.com)06/01 Report--

Work arrangement, need to optimize the sql in oracle10g, know that the em tool of oracle can optimize the system, so do the following.

Baidu found the following link and wanted to follow the steps to optimize sql:

Http://blog.csdn.net/binyao02123202/article/details/19323381

But after entering, I found that the oracle of the appeal blog is 11g. I can't find it on 10g at all. The screenshot below is as follows:

To this end, I felt that 10g em tools could not optimize sql, but after trying successfully all morning, I found a way to optimize 10g sql.

The steps are as follows:

1: enter the em management tool, and guide the top-level activities in the center below-sql optimization guidance.

2: you can see the following screenshot:

3: go to plsqldev to execute the sql that you need to optimize, then wait here for a few minutes, refresh, and you will see a new sql/id. Put the mouse on it and hover to see if part of the sql is your sql.

4: check your sql activities and click the scheduling SQL optimization guide to enter the optimization interface.

5: default settings, click OK.

It is best to show the optimization tips given by the system, if the new index can be achieved, you can click to implement, the system will automatically build an optimized index for you, and other tips are for reference only.

Note: the optimization of the em system is only an auxiliary tool that comes with oracle, and you have to study sql for specific optimization.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.