Re: Foreign key & User defined Index Difference

Article View: borland.public.interbase.sql

Article #489

Back to borland.public.interbase.sql Previous Next

#489

From: Karol Bieniaszewski
Date: Fri, 07 Dec 2007 10:56

14 lines
1343 bytes

U�ytkownik "Maxim Shiryaev" <MaximShiryaev@gmail.com> napisa� w wiadomo�ci 
news:47555f39@newsgroups.borland.com...
> And depending on IB version you can deactivate and activate simple 
> indicies
> using "ALTER INDEX ... [IN]ACTIVE" to rebalance the index tree while you
> cannot do it with FK.
>
> Maxim.
>
you only can not inactive
but you can rebalance index by caling ALTER INDEX ... ACTIVE

Karol Bieniaszewski

Technical Details

Message-ID: <475924c9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <474fc025$1@newsgroups.borland.com> <47555f39@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,e8cd02e29a9aa333
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII
From: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
Newsgroups: borland.public.interbase.sql
References: <474fc025$1@newsgroups.borland.com> <47555f39@newsgroups.borland.com>
Subject: Re: Foreign key & User defined Index Difference
Date: Fri, 7 Dec 2007 11:56:18 +0100
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.205.151.58
Message-ID: <475924c9$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1197024457 195.205.151.58 (7 Dec 2007 02:47:37 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message