partitioning performance

IDS 11.70.fc3xc Aix 6.1 Having to rework some fragmentation that was designed several years ago .. and had a question .... in a fragment by expression clause...arethe following going to perform the same ... fragment by expression transaction_date between '01/01/2014' and '01/15/2014' in fragment_1 ... fragment by expression ((transaction_date >= '01/15/2014') and (transaction_date <= '01/15/2014')) in fragment_2 thanks ... Peter Logan Senior Database Administrator Phone: 616/878-8309

Yes, they will. The trick is to put the ones which are going to get inserted into first = at the top of the list, and remember that the clause gets read left to = right, so make sure that the most exclusive part of the formula comes = first. Of course if you are doing date partitioning, you just want the = most recent date at the top of the list. You might look at the interval fragmentation clause, or the 12.1 Window = clause - which automatically ages data off for you and adds new = fragments as needed. j. On Sep 19, 2013, at 4:07 PM, "Peter_Logan@spartanstores.com" = <Peter_Logan@spartanstores.com> wrote: > IDS 11.70.fc3xc=20 > Aix 6.1=20 >=20 > Having to rework some fragmentation that was designed several years = ago ..=20 > and had a question .... in a fragment by expression clause...arethe=20 > following going to perform the same ...=20 >=20 > fragment by expression=20 > transaction_date between '01/01/2014' and '01/15/2014' in fragment_1 = ...=20 >=20 > fragment by expression=20 >=20 > ((transaction_date >=3D '01/15/2014') and (transaction_date <=3D=20 > '01/15/2014')) in fragment_2=20 >=20 > thanks ...=20 >=20 > Peter Logan=20 > Senior Database Administrator=20 > Phone: 616/878-8309=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20