Article View: borland.public.cppbuilder.database.ado
Article #188Re: Creating composite primary-keys or indexes at run-time...
From: Vladimir Stefanovic
Date: Thu, 31 May 2007 19:37
Date: Thu, 31 May 2007 19:37
20 lines
1414 bytes
1414 bytes
> Connect and execute SQL command: > > CREATE INDEX IX_MyIndex ON MyTable (Word, Lang) > > or, better, add new column ID counter and define PK on it. > Counter is integer and index on it will require less space than index > on string column. Thank you very much! Haven't tested it though, but I do not doubt it will work. The idea with a new Integer PK column is great (I wonder how I overlooked such solution)! -- Best Regards, Vladimir Stefanovic
Technical Details
Message-ID:
<465f23ec$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<465f19ac@newsgroups.borland.com> <465f1e4c@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,73386e07f30a2d6f X-Google-Attributes: gid10698b,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Vladimir Stefanovic" <antivari@po.sbb.co.yu> Newsgroups: borland.public.cppbuilder.database.ado References: <465f19ac@newsgroups.borland.com> <465f1e4c@newsgroups.borland.com> Subject: Re: Creating composite primary-keys or indexes at run-time... Date: Thu, 31 May 2007 21:37:13 +0200 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 NNTP-Posting-Host: 87.116.181.111 Message-ID: <465f23ec$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1180640236 87.116.181.111 (31 May 2007 12:37:16 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail