What Are Indexes
What Are Indexes?
✍: fyicenter.com
Indexes are optional structures associated with tables used to speed query execution and/or guarantee uniqueness. Create an index if there are frequent retrieval of fewer than 10-15% of the rows in a large table and columns are referenced frequently in the WHERE clause. Implied tradeoff is query speed vs. update speed. Oracle automatically update indexes. Concatenated index max. is 16 columns.
2007-04-15, 4614👍, 0💬
Related Topics:
What Is Posting
What Is Posting? Posting is an event that writes Inserts, Updates and Deletes in the forms to the database but not committing these transactions to the database. 2007-04-15, 6562👍, 0💬
What Are TTITLE and BTITLE
What Are TTITLE and BTITLE? TTITLE and BTITLE are commands to control report headings & footers. 2007-04-15, 5193👍, 0💬
In What Order Different Parts of SQL Statements Are Executed
In What Order Different Parts of SQL Statements Are Executed? Where clause, Group By clause, Having clause, Order By clause and Select. 2007-04-15, 4814👍, 0💬