Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - What Is a Table Index

By: FYIcenter.com

(Continued from previous topic...)

What Is a Table Index?

Index is an optional structure associated with a table 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 Database 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.

(Continued on next topic...)

  1. What Is Oracle?
  2. What Is an Oracle Database?
  3. What Is an Oracle Instance?
  4. What Is a Parameter File?
  5. What Is a Server Parameter File?
  6. What Is an Initialization Parameter File?
  7. What Is System Global Area (SGA)?
  8. What Is Program Global Area (PGA)?
  9. What Is a User Account?
  10. What Is the Relation of a User Account and a Schema?
  11. What Is a User Role?
  12. What Is a Database Schema?
  13. What Is a Database Table?
  14. What Is a Table Index?
  15. What Is an Oracle Tablespace?
  16. What Is an Oracle Data File?
  17. What Is a Static Data Dictionary?
  18. What Is a Dynamic Performance View?
  19. What Is a Recycle Bin?
  20. What Is SQL*Plus?
  21. What Is Transport Network Substrate (TNS)?
  22. What Is Open Database Communication (ODBC)?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...