When you create the index, Oracle performs a full table scan, collecting the smbolic key and ROWID for each row in the table. Plus, Oracle writes the TEMP segments in discontiguous segments. A rough estimate is to multiply the ROWID*symbolic_key*num_rows, times a fudge factor of 1.5.
Dig Deeper on Oracle database design and architecture
Related Q&A from Don Burleson
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ...continue reading
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed...continue reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.