Re: How does Oracle handles indexing?

Ok, Jim, what you said seems to make sense, initially, I checked all the indexes for a table then ran a query against a column within, I noticed a new index on that column was added, so I assumed MS SQL Server's ability of "index on-demand", then, I was a bit puzzled, I knew the trade-off/balance of indexing vs. data insertion/update. Just now, I tried query other tables and other databases and I noticed no new index were added, so, it seems that that particular table may have a trigger that did the trick, (btw, can a trigger be hidden?) How to view triggers other than using Enterprise Manager type of GUI utility view?

However, would it be helpful to improve query efficiency by adding a new index when a table is being queried a thousand times, say, within 2 hours, well, where to get the statistics? how about log? would log (suppose, enabled) have sufficient data for this calculation?

Regards,

DL

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<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 - 23:45:32 CET