My Work Journal

A journal of Programming, Technology and Management notes

Wednesday, September 7, 2011

Query to get a list of tables without any indexes

SELECT table_name
  FROM (SELECT table_name FROM user_tables
        MINUS
        SELECT table_name FROM user_indexes) orasnap_noindex
 WHERE table_name LIKE 'HSO%'
ORDER BY table_name
Posted by Harry at 4:22 PM 0 comments
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Database, Programming
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Labels

  • Database (7)
  • Java (7)
  • Management (18)
  • Outlook (1)
  • Programming (21)
  • Project Management (3)
  • Unix (7)

Blog Archive

  • ►  2025 (1)
    • ►  May (1)
  • ►  2024 (9)
    • ►  December (1)
    • ►  August (1)
    • ►  July (2)
    • ►  June (1)
    • ►  May (2)
    • ►  March (1)
    • ►  January (1)
  • ►  2023 (1)
    • ►  October (1)
  • ►  2020 (5)
    • ►  July (2)
    • ►  March (2)
    • ►  February (1)
  • ►  2019 (2)
    • ►  August (1)
    • ►  January (1)
  • ►  2017 (1)
    • ►  October (1)
  • ►  2016 (3)
    • ►  April (3)
  • ►  2015 (2)
    • ►  August (1)
    • ►  February (1)
  • ►  2014 (2)
    • ►  November (2)
  • ►  2013 (3)
    • ►  September (2)
    • ►  March (1)
  • ▼  2011 (9)
    • ►  November (1)
    • ►  October (3)
    • ▼  September (1)
      • Query to get a list of tables without any indexes
    • ►  August (2)
    • ►  March (2)
  • ►  2010 (1)
    • ►  April (1)
  • ►  2009 (6)
    • ►  June (5)
    • ►  February (1)
  • ►  2008 (4)
    • ►  December (2)
    • ►  January (2)
  • ►  2007 (1)
    • ►  October (1)
  • ►  2006 (3)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)

About Me

  • LinkedIn Profile
  • About Me
Picture Window theme. Powered by Blogger.