Re: How does Oracle handles indexing?
Date: Wed, 30 Jan 2002 03:23:51 GMT
Message-ID: <bHJ58.4275$Tu1.8427_at_rwcrnsc51.ops.asp.att.net>
Some front end tools might create an index on a column that was searched,
but AFAIK MS SQLServer does not.(neitherr does Oracle)
Oracle has a whole lot of choices for indexing. indexes, unique indexes,
bitmapped indexes, clustered indexes (which are not the same thing as a MS
SQL Server clustered index) , index organized tables, intermedia text index,
function based indexes. I think I got them all.
Jim
"DL" <donlcs_at_yahoo.com> wrote in message
news: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 Wed Jan 30 2002 - 04:23:51 CET