OP,
You need to be more specific about your particular bike and paint job. A pic would help. Matte finish bikes for example can be a disaster with any fine polishing compound.
If a gloss finish, you have a lot of options. Post a picture of the scratch if you want the best answer and technique.