In general, powders burn the cleanest when at max pressure for a given velocity. It also serves to minimize the total amount of powder used.
Other than the VV powders, Clays is a very fast powder and burns cleanly. In your case would be usable only in 45 for moderate loads.
You also haven't mentioned if you are using a comp with 9mm Major. If so, you will need a slightly slower powder so the pressure is maintained further out along the barrel for the comp to be more effective.