Re: Dumb Question regarding Indexes

On Fri, 29 Jul 2005 09:04:48 -0700, Perm interested us by writing:

> I am a bit confused about creating indexes. If I have a table with 5
> columns, do I create an index for each column, or create an index for
> all columns in the same index, or what??

From the Oracle9i R2 Database Administrator's manual, Intro to Chapter 16

"
Indexes are optional structures associated with tables and clusters that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle index provides a faster access path to table data. You can use indexes without rewriting any queries. Your results are the same, but you see them more quickly. "

Please note the 'optional structures' part.

Feel free to read the entire chapter and ask questions on areas that confuse you. The manual is available at http://docs.oracle.com

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***