I have a query like this:
EXPLAIN SELECT dictionary.id, dictionary.word, lwd.grammatical_role, lwd.phonetics
FROM loghatnameh_dehkhoda dictionary
LEFT JOIN loghatnameh_words_details lwd ON lwd.word = ...
I am using SQL Server Management Studio 17.9.1 with SQL Server 2016 Service Pack 2 (SP2).
There is no table structure to show, just two XML variables that contain XML, as shown below:
DECLARE @A XML = ...
Consider the following type of query, which has many joins:
select t0.*, t1.*, etc..
left join t1 on t0.t1_id = t1.id
left join t2 on t0.t2_id = t2.id
left join t11 on t0.t11_id = t11.id
First of all I am sorry if this is a basic question, I am new to queries in MongoDB. Well, what I need is to find the latest registers for a worker in my WorkerLocationContext document and the latest ...
PostgreSQL 13.2 (Debian 13.2-1.pgdg100+1) on x86_64-pc-linux-gnu,
compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
I'm a bit stuck on this one.
Currently I am using this query:
I've been investigating an issue with a slow query when trying to get the last 50 comments of a user.
To give some context the database size is 9 TiB and the COMMENT table has about 7 billon of rows.
Have this MySQL SELECT query:
SELECT product.id, product.name, shop.currency, price.amount, shop.name
FROM product LEFT JOIN price ON product.id = price.product_id
LEFT JOIN shop ON price.shop_id = ...
I need to create a database structure for a 1v1 game.
This is what I have designed so far.
Now here is the problem: I want to display all the data of matches on the screen, but instead of the foreign ...
Caused by some bad design decisions, I have to make sure that a random-character string (no sequence!) must not appear twice in three different MySQL tables (TableA, TableB, TableC). So if the value &...
I've been noticing some strange occurrences lately on my development SQL Server instance where the Nested Loops Physical Join Operator is used when a Hash Join would be much more efficient, within a ...
I have two mapping tables as
CREATE TABLE ProjectDevelopers
DeveloperID int(11) unsigned NOT NULL,
ProjectID int(11) unsigned NOT NULL,
I got a peculiar requirement to create a SQL query joining 2 tables as below
customer is the first table. This table holds the primary (p) and other (o) customers. The field cust_id creates the link ...
I have 3 tables and I only need to compare data between 2 of them but only taking in mind the latest row. The structure of the table is as follows
EXPLAIN shows that PostgreSQL chooses a bad plan for hash join. it should have first iterate by tags_name_value_height2 in the table tags and use it to find corresponding transactions.id, but instead ...