HP Software Developers Blog
HP Software Developers thought leadership around software architecture and design, cloud data modeling, mobile technologies, big data, performance programming and more.

Database SQL CTE tables: Why are they good for you

CTE, Common Table Expression, known also as WITH clause, has been around for some time as part Oracle and SQL Server relational database engines. It serves many purposes such as recursive queries and reuse of internal result sets; yet many database technologists do not use it. I will demonstrate a simple use case showing the benefits of CTE.

The post is written by Sharon Dashet (Expert Oracle DBA).

Labels: Databases

Oracle HAKAN Factor During Partition Exchange

Amongst the best performance functionalities in the Oracle Enterprise server is good old table partitioning, introduced way back in release 8.0.

If you are an experienced Oracle DBA, you've probably used partitioning at one point or another. As you added/dropped/exchanged/split/merged/rebuilt partitions in your data warehouse, you were quite confident that nothing would surprise you…

Well, what does the following message tell you?

ORA-14642
Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Error Cause:
The two tables in the EXCHANGE have usable bitmap indexes, and the INCLUDING INDEXES option has been specified and the tables have different hakan factors.

 

H a k a n factor???

Labels: Databases
Search
Showing results for 
Search instead for 
Do you mean 
About the Author(s)
  • I've been all over the coding world since earning my degrees have worked several years in c++ and then several in java, finally setteling into c# about 7 years ago, where i spent a good amount of my time in Performance tweaking & memory debugging, as well as designing new solutions and hacking at old ones to stay in line. Computers never cease to amaze me, and i'm glad to have found a field where i get paid to do what i enjoy. some of my tools and thoughts are also stored in codeproject, and you are welcome to check them out there.
  • work as a Senior Technologist in HP Software ALM CTO office. Past experience include chief architect for Application performance management, QA manager for Business service management, developer for Real User management
  • This account is for guest bloggers. The blog post will identify the blogger.
  • Research Architect @HPSW, focused on what ALM means for developers, DevOps, user experience and other emerging practices. Previously was a functional architect and a developer in HP ALM and HP UFT products.
  • Seasoned architect with over 12 years of experience in the enterprise software business, contributing to setting the roadmap / vision, high level architecture and technology review, innovation management and product integration within HP Software portfolio.
  • Lior has over 15 years experience in the software industry in various roles – experienced in Enterprise Software and team build up . Lior Managed the HP Software ALM PCoE Group where he focused on the domain of application development and application performance management .
  • Malcolm is a functional architect, focusing on best practices and methodologies across the software development lifecycle.
  • Architect and User Experience expert with more than 10 years of experience in designing complex applications for all platforms. Currently in Operations Analytics - Big data and Analytics for IT organisations. Follow me on twitter @nuritps
  • CTO Office, Product Foundation Services, HP Software
  • Yaniv Sayers has over 15 years of experience in the IT and software industry, including software design, R&D and IT operations. Holds expertise in various spaces including IT operations, ITIL, ALM, Agile, Cloud, DevOps, Mobility and Software Architecture and Design. In current capacity Yaniv is a CTO in HP Software IT Management, responsible for planning and driving technology and innovations strategy with emphasized focus on solutions for agile development, DevOps, mobility and cloud.
HP Blog

HP Software Solutions Blog

Featured


Follow Us
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.