Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Just to clarify index options ... |
Tue, Feb 7 2006 6:51 AM | Permanent Link |
Tim Shields | Hi all,
Sorry to be a pain asking this question, but am a little confused over what type of index's to create - just want some definitive clarification : I have a text field, say aField CHAR(20) that I search on using : SELECT * FROM aTable WHERE UPPER(aField) LIKE 'ASTRING%' What type of index/compression/case-sensitive etc should I create on aField??? TIA, Tim. |
Tue, Feb 7 2006 7:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I would go for case-insensitive full compression BUT you need to alter your sql to SELECT * FROM aTable WHERE UPPER(aField) LIKE UPPER('ASTRING%') Roy Lambert |
Tue, Feb 7 2006 11:15 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Tim,
<< What type of index/compression/case-sensitive etc should I create on aField??? >> Roy is correct - case-insensitive index with full compression, and make the adjustment to the query to include the UPPER() around the constant. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 7 2006 11:27 AM | Permanent Link |
Tim Shields | Thanks guys - Takes the guess work out of it all when your brain has been fried from 3 days non-stop solid coding ..... Can now sleep .... ahhhhhhh....... > Tim, > > << What type of index/compression/case-sensitive etc should I create > on aField??? >> > > Roy is correct - case-insensitive index with full compression, and > make the adjustment to the query to include the UPPER() around the > constant. > |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |