Discusses traditional AI challenges/solutions as well as the concepts underpinning data mining.
To create a index on a single column, do this:
CREATE INDEX IDX_FERC ON FERC(FercName)
In some cases, you may have a need to combine columns to hasten known unique combinations. This is knonw as a composite key. An example:
CREATE INDEX IDX_OperatingCompanyFERC ON FERC(OpCompanyID,FercName)