Re: Foreign key & User defined Index Difference

Article View: borland.public.interbase.sql

Article #473

Back to borland.public.interbase.sql Previous Next

#473

From: Maxim Shiryaev
Date: Tue, 04 Dec 2007 14:08

5 lines
1125 bytes

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.

Technical Details

Message-ID: <47555f39@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <474fc025$1@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-7-bit
From: "Maxim Shiryaev" <MaximShiryaev@gmail.com>
Newsgroups: borland.public.interbase.sql
References: <474fc025$1@newsgroups.borland.com>
Subject: Re: Foreign key & User defined Index Difference
Date: Tue, 4 Dec 2007 17:08:34 +0300
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.234.197.62
Message-ID: <47555f39@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196777273 213.234.197.62 (4 Dec 2007 06:07:53 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message