SQL FAQ: Table of Contents

SQL Standard

• What is SQL?
• What is SQL2?
• What is SQL3?
• What are the SQL reserved words?

How To's

• How do you tell what other database objects exist?
• How do you do UNIX-like wildcard searches?
• How do you extract just the month from an abstime?
• How do you remove duplicate entries from a table?
  • Using a temporary table to remove duplicates.
  • Using oid to remove duplicates.

Query Performance

• Why does my query take so long to run?
• How does running vacuum make queries run faster?
• How can I tell what indices a table has?
• How can I tell which index Illustra is using?
• Can I tell Illustra which index to use?

Join Problems

• I get too many rows when I join two tables.
• I don't get enough rows when I join two tables.
• Another way to do joins using Illustra ref().

Back to top level FAQ.

Last modified 30-June-94 (Illustra Rev 2.0.12)