Home -> Usenet -> comp.databases.oracle -> How does Oracle handles indexing?

How does Oracle handles indexing?

From: DL <donlcs_at_yahoo.com>
Date: 29 Jan 2002 14:55:43 -0800
Message-ID: <604bb90c.0201291455.10bc55ce_at_posting.google.com> 






Hi,



My understanding with MS SQL Server is, 
type of indexing (clustered, not clusterd or unique), 
some CASE tool would create a non-clustered index on PK during data
model transformation; one may also create an index on a column by
hand;


and an index would be automatically created after a search is
performed against a column (not of data type 'bit', 'text', 'image')
which does not have an index yet (my term, index on-demand?).  
What's|are Oracle's counterpart(s)?



Thank you very much.



DL
Received on Tue Jan 29 2002 - 23:55:43 CET












Original text of this message