Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Index and Foreign key

Index and Foreign key

From: Salim Harouat <salimharouat_at_aol.com>
Date: Sat, 26 Apr 2003 08:01:58 +0000 (UTC)
Message-ID: <a681b2ad8910e034900c78ce18a6adf7.16142@mygate.mailgate.org>


Hi Everybody,

  I wish to optimize certain queries done on a Oracle database to gain in response times. With this intention, I plan to pose a non unique index on each foreign key of the base. Am i right ?

Thank u for everything

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Sat Apr 26 2003 - 03:01:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US