• >>Should I create these indexes during the schema creation or after the populations scripts?

    Create indexes after pupulating the data.

    Benefits:

    1) Data population will be faster as there is no index update.

    2) New index will be free from fragmentation.