Navicat Blog

How to Tell when it's Time to Rebuild Indexes in Oracle Jan 15, 2020 by Robert Gravelle

Every so often, we need to rebuild indexes in Oracle, because indexes become fragmented over time. This causes their performance - and by extension - that of your database queries, to degrade. Hence, rebuilding indexes every now and again can be quite beneficial. Having said that, indexes should not be rebuilt to often, because it's a resource intensive task. Worse, as an index is being rebuilt, locks will be placed on the index, preventing anyone from accessing it while the rebuilding occurs. Any queries trying to access this index in order to return the required results will be temporarily blocked, until the rebuild is complete.

In today's blog, we'll learn how often to build indexes and how to determine when an index needs to be rebuilt.

Storing Images in MySQL with Navicat Jan 08, 2020 by Robert Gravelle

The number of images in web applications has been growing steadily in recent years. There is also a need to distinguish between images of different sizes, like thumbnails, web display images, and the like. For example, one application that I recently developed shows news items where each item has a thumbnail and main article image. Another app shows company logos in small and large sizes.

Navicat Premium 15 - the Most Powerful Yet! | Navicat Blog Dec 30, 2019 by Robert Gravelle

Perhaps you've heard that version 15 of Navicat's flagship product, Navicat Premium, was officially released on November 25th. It comes packed with numerous improvements and features to address all of your database development and administration needs. In addition to over 100 enhancements, Navicat includes several new features to give you more ways that ever to build, manage, and maintain your databases. In the last blog, we explored the Data Visualization feature. Today, we'll be taking a look at other improvements, including Data Transfer, Query Builder, Data Modeler and more!

Perform Full-text Searches in MySQL (Part 3)| Navicat Blog Dec 19, 2019 by Robert Gravelle

Welcome to part 3 of this series on full-text indexing and searching in MySQL. In Part 1, we saw how MySQL provides full-text search capability via FULLTEXT indexing along with the three following distinct types of full-text searches:

  • Natural Language Full-Text Searches
  • Boolean Full-Text searches
  • Query expansion searches

In Part 2, I described how to perform Natural Language full-text searches in Navicat for MySQL. Today's blog follows where part 2 left off and covers the next type of full-text searching: Boolean Full-Text searches.

Dec 10, 2019 by Robert Gravelle

November 25 is the official launching date for Navicat Premium 15. Currently, version 15 packs a wallop of new features and improvements, most notably in data transfers, the SQL Builder, and modeling. It also adds Data Visualization, Dark Mode and native Linux support. In today's blog we'll learn how the new Data Visualization feature helps us turn our database into visuals that provide valuable insights into our data through a wide variety of charts and graphs.

Navicat Blogs
Feed Entries
Blog Archives