var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: automatically indexed
Easy question, couldn't find in our oracle-pdfs. When I make a primary key on a table. will ths primary key automatically be indexed?
ALTER TABLE ISH.Employee ADD CONSTRAINT pk_Employee PRIMARY KEY( EmpId );
Indexes are automatic
If you look through PDFs on otn.oracle.com, you would find enough documentation on indexes.
By the way, indexes are controlled by the system when u have the primary key, and unique constraints.
So whenever u have a column as the primary key, an index is created on that column.
If that Index would be used in a query or not, would be controlled by Oracle execution path, what oracle decides.
Do let me know if you need more specific information on indexes.
Thanx and Regards
No, you need to add the using index clause.
and dont forget to analyze the table if your not using the rule based optimizer.
Take it back, it will create an index by default in the same tablespace as the table. You should still use the 'using index' clause though as then you can specify a different tablespace (i.e. disk/stripe) for the index to improve performance.