Ask Paula!

...bringing you notes from the field...

  Home  |   Contact  |   Syndication    |   Login
  121 Posts | 5 Stories | 94 Comments | 0 Trackbacks

News

Copyright © 2008-2015 Paula DiTallo

Tag Cloud


Article Categories

Archives

Post Categories

Image Galleries

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

Artificial Intelligence

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)