help with fragmentation scheme
Posted in 2009
We have to fragment a table now because of nearing the page limit size. Yes we could just change the page size but think at 240million rows, it's probably a good thing to fragment the table anyway. Most queries join that table to other tables based on the token and joined to another field(stprofil_token). The other field has values that are spread througout the token range. So if we fragmented on the token field, it would be good to eliminate the proper fragment, but that would have to happen many times until it found the right record that contains the token/stprofil_token value. So would the best thing be to try and find a good split of data between those 2 fields ? Like see if I can fragment with an expression like: token >;=x and token ;=a and stprofil_token