Home -> Usenet -> comp.databases.oracle -> primary key index

primary key index

From: iskon.hr <mladen.basic_at_willevolve.com>
Date: Sat, 22 Feb 2003 15:54:43 +0100
Message-ID: <b38310$abh$1_at_sunce.iskon.hr> 






hello,




using usual general data in select statement from table like :

1. primary key
2. names
3. code
4. some kind of general info... etc






tells me to expand primary key with these values!


(because B-tree index take values of column).


But, in the other hand I have primary key and declaring same index twice


(pk,col1,col2...) is not smart decision!





Any suggestions???




MB
Received on Sat Feb 22 2003 - 15:54:43 CET












Original text of this message