Foreign key & User defined Index Difference

Article View: borland.public.interbase.sql

Article #467

Back to borland.public.interbase.sql Previous Next

#467

From: Monalee Bhandge
Date: Fri, 30 Nov 2007 06:47

8 lines
1285 bytes

Hi,
  I want to ask only the difference between user defined index & the index that created while defining the foreign key.
  I have two table emp_master & empl_details.The primary key of emp_master is foreign key for emp_details.When I asign foreign key then it automaticaly create index on it.But now I want to remove that trigger, instead I want to create trigger.I externaly create index on that column.
  So, will it make the difference for retrive the data from tables and how it effects?

Thanking you,
Monalee Bhandge.

Technical Details

Message-ID: <474fc025$1@newsgroups.borland.com>

Path:

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

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,e8cd02e29a9aa333,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Monalee Bhandge" <monaleeb@gmail.com>
Sender: "Monalee Bhandge" <monaleeb@gmail.com>
Reply-To: "Monalee Bhandge" <monaleeb@gmail.com>
Subject: Foreign key & User defined Index Difference
Newsgroups: borland.public.interbase.sql
X-User-Info: 59.91.214.151     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <474fc025$1@newsgroups.borland.com>
Date: 29 Nov 2007 23:47:49 -0700
X-Trace: newsgroups.borland.com 1196408869 207.105.83.66 (29 Nov 2007 23:47:49 -0700)
Lines: 8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail