Add the following line to your httpd.conf file. Be sure it is outside of any <directory> containers. Then restart the server:

ScriptAlias /loadpage "/absolute path from root to/index.cgi"

Now you can call urls as:

http://www.mydomain.com/loadpage?10

The 10 will be the value of $ENV{QUERY_STRING} in index.cgi