Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
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, 4460👍, 0💬
Popular Posts:
What is the concept of XPOINTER? XPOINTER is used to locate data within XML document. XPOINTER can p...
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
How comfortable are you with writing HTML documents entirely by hand? Everyone has a different prefe...
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
If client side validation is enabled in your Web page, does that mean server side code is not run? W...