Skip to the main content.
Downloads Try Thriftly
Downloads Try Thriftly
Group 762

Migrate and run DataFlex applications with Oracle, MS SQL Server, PostgreSQL, MySQL &  MariaDB.

flex2Crystal

Stuck in Crystal XI?  Upgrade and use the latest versions of Crystal Reports with DataFlex applications. 

BTR2SQL

Convert from Btrieve / P.SQL / Actian transactional engines to Oracle, MS SQL Server, and PostgreSQL

thriftly-1

Quickly build multi-protocol web services with the same API. Supports JSON-RPC, REST, SOAP,  Thrift, and gRPC.

 Group 671-1

 

  Education
Why Mertech?

Query Access Plan in Oracle

Picture of Mertech Mertech : Feb 25, 2008 3:09:00 PM

Databases

A lot of developers use embedded SQL, or other tools to access their data. If a query is not optimized it can cause problems.


An easy way is to check the access plan is through the SQL Worksheet. In Oracle XE click the 'explain' tab, and in the regular server click the 'plan' tab.


Be especially wary of full table scans (TABLE ACCESS FULL).


Oracle 10g Enterprise Manager (OEM) Alerts section has a very good list of suspect queries... When they have been prepared too many times (Duplicate SQL), taking too much CPU or disk access, etc. You can also look at the Performance Tab - especially the Top SQL section.


Recommendation: Test your queries to see the access plan. Encourage customers to test their embedded SQL.

 
Legacy Application Modernization: Key Steps, Benefits & Best Practices

Legacy Application Modernization: Key Steps, Benefits & Best Practices

Picture of Mertech Mertech: Mar 29, 2024 8:53:00 AM

This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.

Cloud and hybrid cloud Modernization
Read More
Hybrid Cloud Migration: Plan, Process and Advantages

Hybrid Cloud Migration: Plan, Process and Advantages

Picture of Mertech Mertech: Mar 7, 2024 4:32:00 PM

This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.

Cloud and hybrid cloud Thriftly
Read More
Financial Benefits of Cloud Migration & Hybrid Cloud Applications

Financial Benefits of Cloud Migration & Hybrid Cloud Applications

Picture of Mertech Mertech: Mar 5, 2024 5:06:00 PM

Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...

Webinars API development Cloud and hybrid cloud Thriftly
Read More