Please could yuo assist with the following. I have a table that consists of accounts and record ids(one account can have multiple record ids). I would like to find the min and max value per account, I am able to do this using min and max functions, but found that this takes quite a long time on large data sets but i do get the desired result. I would like toknow if there are other faster methods of achieving this. My table consists of 100 mil rows.
Calculate them in the script if you don't already. If that still takes to long you could try to have the source database calculate them for you. You could ask your local friendly Database Administrator for help or advice on that.
