Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 3 of 3 total |
Which index type for simple 'secondary' index? |
Thu, May 26 2011 3:05 AM | Permanent Link |
Adam H. | Hi,
I was wondering - which index type should I be using in EDB Manager to specify a field that will be used in a WHERE SQL clause in EDB to increase the performance of SQL? The only options I have available are: Primary Key Unique key Foreign, and Check .... but none of these seem to make sense to me, as the field is neither unique, nor a primary, nor a foreign, and doesn't require any check / constraints at all? Cheers Adam. |
Thu, May 26 2011 3:43 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
You're looking in the wrong place. Take a squint at the tree on the left. If you open up any of the table branches (click on the triangle don't double click) you'll see another branch Indexes. Click on that and you'll be allowed to create an new index. The create / alter table dialog now only deals with the primary key or constraints. Roy Lambert |
Thu, May 26 2011 6:52 PM | Permanent Link |
Adam H. | Perfect Roy - thanks for that - got it!
Cheers Adam. |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |