This is a for regular fastcgi. 

LoadModule fcgid_module modules/mod_fcgid.so

<Location /fcgid>
    SetHandler fcgid-script
    Options ExecCGI
    allow from all
</Location>

This is for suEXEC. Please get more information about suEXEC here. 

LoadModule fcgid_module modules/mod_fcgid.so

<Location /fcgid>
    SetHandler fcgid-script
    Options ExecCGI
    allow from all
</Location>

<VirtualHost 192.168.1.89>
    ServerAdmin webmaster@host.foo.com
    DocumentRoot /usr/local/apache2/htdocs/
    ServerName host.foo.com
    SuexecUserGroup pqf pqf
</VirtualHost>

This is for fastcgi-mode PHP (UNIX)

LoadModule fcgid_module modules/mod_fcgid.so

<Directory /usr/local/apache2/htdocs/php>
    SetHandler fcgid-script
    FCGIWrapper /usr/local/bin/php .php
    Options ExecCGI
    allow from all
</Directory>

This works too:

LoadModule fcgid_module modules/mod_fcgid.so 

AddHandler fcgid-script .php
<Directory /usr/local/apache2/htdocs/php>
    FCGIWrapper /usr/local/bin/php .php
    Options ExecCGI
    allow from all
</Directory>

# Please make sure:
# php is configured with --enable-fastcgi option
# check error_log(with debug level), if any thing goes wrong

This is for suPHP  ( UNIX )

LoadModule fcgid_module modules/mod_fcgid.so

<VirtualHost *:80>
    ServerName test2.example.com
    DocumentRoot /usr/local/apache2/htdocs/test2.example.com/
    SuexecUserGroup pqf pqf
</VirtualHost>

<Directory /usr/local/apache2/htdocs/test2.example.com/>
    AddHandler fcgid-script .php
    Options ExecCGI
    allow from all
    FCGIWrapper /usr/local/apache2/htdocs/test2.example.com/php .php
</Directory>

# Please make sure:
# php is configured with --enable-fastcgi option
# copy php execution to /usr/local/apache2/htdocs/test2.example.com/ directory
# make sure all files in /usr/local/apache2/htdocs/test2.example.com/ with right owner and group
# check error_log(with debug level) and suexec_log, if any thing goes wrong

This is for fastcgi-mode PHP ( Windows )

LoadModule fcgid_module modules/mod_fcgid.so

<Directory "C:/Apache2/htdocs/php/">
    SetHandler fcgid-script
    Options execCGI
    AllowOverride None
    Order allow,deny
    Allow from all
    FCGIWrapper "c:/php/php.exe" .php
</Directory>

This works too:

LoadModule fcgid_module modules/mod_fcgid.so 

AddHandler fcgid-script .php
<Directory "C:/Apache2/htdocs/php/">
    FCGIWrapper "c:/php/php.exe" .php
    Options ExecCGI
    allow from all
</Directory>