I would like to know how many yards I should do? if more then one is one better then another?
I'd encourage employing sound fundamentals (sights/trigger) in a slow-fire fashion from 15-25 yards. Unless you're actively under fire from a long gun, pistol shots at greater than 25 meters would mean you likely have other options.
Then, as you move closer toward the target, say at 10-12 meters, develop double and triple taps drawing from the holster (if your range permits - otherwise find a new range!). Off hand and one hand shooting at 10 meters too. This is where you begin to hone your "smooth quickness" from the holster to scoring hits on target. This distance is a great "yard line" to race yourself with smooth, efficient magazine transitions too. Push yourself to improve, execute more quickly, and put more scored/timed shots on target.
Then keep moving forward. Essentially, the closer you get to your target(s), the quicker you're operating - and you may or may not even realize you're using your front sight less and less when you up to 3-5 meters. Instinctive snap-shooting, shooting while moving, and shooting multiple targets up to and within 5 meters - all from the holster, so you're actually training the way you'd fight - is great way to determine where your CC handgun skills really are. Don't hope you're ready, or even think you're ready. KNOW you are ready and refer to your own training log to track your own progress. (Times, scores etc.)
Sight shooting at 25 meters is cool, and a great way to maintain fundamental proficiency.If you're training for a match, I'm all for spending time at 25m. Otherwise, lots of training with snap-shooting "up close and personal" where most handgun encounters occur is a great way to train to win and live.
Lastly, before you head to the range, set some training goals for yourself. Show up with a plan to actually work on and improve certain aspects of your shooting skills, and track your progress. Push yourself if you attain your goals too easily, and readjust if they're unattainable. If you know you need more time drawing and presenting more quickly, race yourself. A buddy with a stopwatch is an effective and safe "stress inducer" that can push you to improve. Scoring rapidly delivered double & triple taps with points and time is a great way to force you to stay sharp, focused and continually developing your skill (and confidence).
Don't just go plinking. Train, and then don't just train. Train the way you fight - and fight to win and live.
IMHO.