Geeks With Blogs

News Copyright © 2008-2015 Paula DiTallo
Ask Paula! ...bringing you notes from the field... Artificial Intelligence Discusses traditional AI challenges/solutions as well as the concepts underpinning data mining.
How do I create an Index that is NOT the primary on my tables?

To create a index on a single column, do this:


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)

Posted On Monday, November 2, 2009 8:07 AM

Copyright © Paula DiTallo | Powered by: | Join free