Re: Performance bei SELECT
Mh, stimmt schon, allerdings brauche ich die Abfragen manchmal so.
Manchmal will man halt eine Übersicht über alle Marken und wieviel davon verkauft / im Lager usw. ist ... da ist dann die einzige Einschränkung der Zeitraum - alles andere geht wirklich über die komplette items-Tabelle und invoicelines ... ganz ohne Suchkriterium und gruppiert nach Brand oder manchmal auch nach Parent (Hauptprodukte)
attr_department wird häufiger als Filter verwendet, alleine bringt der aber auch kaum Geschwindigkeit ...
Schwierig, schwierig ...
mark
Subject
Views
Written By
Posted
2609
January 19, 2012 07:17AM
1456
January 19, 2012 12:59PM
1523
January 20, 2012 05:33AM
1738
January 20, 2012 06:10AM
1467
January 20, 2012 07:06AM
1480
January 20, 2012 12:11PM
1443
January 25, 2012 04:11AM
1307
January 25, 2012 04:24AM
1360
January 25, 2012 04:30AM
1288
January 25, 2012 04:49AM
1123
January 25, 2012 06:05AM
1410
January 25, 2012 06:37AM
1389
January 25, 2012 07:46AM
1465
January 26, 2012 12:57AM
1366
January 25, 2012 11:11PM
1240
January 25, 2012 11:50PM
Re: Performance bei SELECT
1147
January 27, 2012 08:27AM
1541
January 27, 2012 06:21AM
1380
February 02, 2012 10:06PM
1089
February 03, 2012 05:34AM
1345
February 03, 2012 02:04PM
1277
February 08, 2012 09:52PM
1321
February 09, 2012 08:41AM
1231
February 10, 2012 02:03AM
1482
February 10, 2012 02:52AM
1377
February 10, 2012 04:51AM
1343
February 09, 2012 11:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.