Nura111
asked on
empty rows
Is that a problem to have empty rows in the database (its in a content table)
can it cause slow queries?
can it cause slow queries?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
To add: I guess it all depends on how you define 'empty' rows. If they are actual nulls, some databases don't index those so if you query based on an index, then no.
If empty rows are part of the actual select and you must do a full table scan then it might.
1 Billion 'empty' rows. One populated. You go after the one, you might have to wait.
It all depends on the database and how it handles things.
If empty rows are part of the actual select and you must do a full table scan then it might.
1 Billion 'empty' rows. One populated. You go after the one, you might have to wait.
It all depends on the database and how it handles things.
What are the use of empty rows? More empty rows more issues and it might affect the queries. You could clean them up if you do not need them.
ASKER
Its a wp_post table (wp database if you are familiar with it) if not just a table that save information on the content and from some reason there is a few rows with empty post_content
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Thank you.