oracle10g - how to increase oracle query when 22,000,000 records in single table? -

-

I have Oracle 10G installed on Windows Server 2003. I have 22,000,000 records in a table and this is a transaction table,
About this table approximately 50,000 per month of the record.

My question is, whenever I run a query on this, my query is very slow, is there any way by which I can improve the performance of the query, such as table split or other ?

Query 

  Select a.prd_code, a.br_code || '-' || Br_title, a.size_code || '-' || Size_chitel, size_in_gomes, averkide || '-' var_title, a.form_code || '-' || Form_chirtle, a pockcode || '-' || Pack_title, a.pack_type_code || '-' || pack_type_title, start_date, end_date, a price, brand Br, (specific prd_code, br_code, size_code, var_code, form_code, packing_code selected a.price, cphistory the pack_type_code where prd_code = '01' flag = 'Y' and project_yy = '2009' and '01' and '10') CP, (prd_code, br_code, size_code, size_in_gms selection of sizes where prd_code = '01' and end_date = '31 -dec-2050 'flag =' Y ') SZ in (select prd_code, br_code, var_code, var_title of varient) vt, (select from prd_code, br_code, form_code, FORM_TITLE form) FM, PC (prd_code, package) Pack_title (select prd_code, Pakck_type to pack_type_title) pt where a.prd_code = br. prd_code and a.br_code = br_br_code and a.prd_code = sz.prd_code and a.br_code = SZ .br_code and a.size_code = sz.size_code and a.prd_code = vt.prd_code and a.br_code = vt.br_code and a. var_code = vt.var_code and a.prd_code = fm.prd_code and a.br_code = fm.br_code and a.form_code = fm.form_code and a.prd_code = pc.prd_code and r_code = pc.br_code and a.pack_code = pc .pack_code and a.prd_code = pt.prd_code and a.pack_type_code = pt.pack_type_code and end_date = '2009' and 'prd_code =' 01 'a.prd_code, order by a.br_code, A.size_code, a.var_code, a. Pack_code, a.form_code

The tables used in this query are: 

  Prices: More than 2.1 m rows cphistory: size more than 2.2M rows Are: more than 5000 Pt Tian brand: It varies more than 1200 lines: There are more than 1800 line package: more than 200 lines Pak_prkar: More than 150 lines

  1. Check out the index. Make sure that you have the primary key, the optional option key must be unique restriction and indexed.
  2. Run an Expansion Plan on questions and see how the adapter is running them. If you see a table scan, add the index.
  3. Make sure the adapter is using data to make its work easier.
  4. Take historical data in warehouses if necessary.

The 22m record is not very big.


Comments

Post a Comment

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

-
I would like to capture all incoming HTTP packets on my machine. To do this, I am using SharpPcap which is a WinPcap The cover is. SharpPcap works very well, but it captures TCP packets and what it wants to do for me is a very low level. Does anyone know how can I easily get full HTTP requests / reactions from all these TCP packets? Thanks SharpPcap is already able to capture the packet in the same way That's what the virus does (just in the code instead of the GUI). And you can either either parse them directly or you can put them in the drive in the common .pcap file format. The steps to parse the capture are: Open a connection at any time Loop a while Or start capturing using an event callback Parsing the raw packet for the type you want If you are reading .PPP dump files In addition to calling you an offline capture reader is almost the same, there is no need to select an interface, and you can set the majority There is no need to do the modes. All st...
Read more

php - Multiple Select with Explode: only returns the word "Array" -

-
By using Wordpress I have created a multiple selection box so that users can select categories to exclude. When the page is initially loaded, I see my predefined default option. However, when I select a new value and I save ... I only see the word "Array" and have not chosen anything else? & lt; Class = "amultiple" id = "& lt; php echo $ value ['id'] ;? gt;" name = "& gt; php echo $ value ['id'] ;; gt; []" Multiple = "multiple" size = "8" & gt; & Lt ;? Php global option; Foreign currency ($ value as value $) {if (get_settings ($ value ['id']) === FALSE {$$ value ['id'] = $ value ['std']; } And {$$ value ['id'] = get_settings ($ value ['id']); }} $ Ranges = & amp; Amp; Categories ('type = post & orderbiz = name & amp; hide_empty = 1'); If ($ ranges) {$ ex_cat = implode (',', $ tt_cat_exclude); Forex Currency ($ range a...
Read more

php - jQuery AJAX Post not working -

-
I do not understand why this script does not work. It has something to do within AJAX PostScript / Function. Right now, when I submit my form, it runs php code on the same page. What it should do, send the values ​​of the form for Project_Azax.fp, then there will be a refund of success on the page which is correct or false. $ (document) .ready (function () {$ ('div # didIt'). Hide (); $ ('form [name = adminForm]'). Submit (function () ($ {'.post' ('/ project_ajax.php', {action: $ ('[name = action]') Val (), pId: $ ('[name = pId]'). Val (), name ('[Name = name]'. Val (), url: $ ('[url = url]'). Val (), summary: ('[summary = summary]'). Val ()}, Function (data) {if (data.success) {$ ('div # didIt') .Sliddown ('slow');} and {warning ('unsuccessful SA!');}}, 'Jason'); return false ;});}); What is the code for project_ajax.php below ... if ($ _ POST ['action'] == ...
Read more