I have an optimisation question here. Background I have a 12000 users in a user table, on record per user. Each user can be in zero or more groups. I have a groups table with 45 groups and a groups
Given the table create table a (x int, y int); create index a_x_y on a(x, y); I would expect a query like select distinct x from a where y = 1 to use only the index, instead it uses the index to fi
This is my simple query in mysql/zend: // Get Patients $table = new Model_Patient_DbTable(); $select = $table->select();
I have this query that\'s running too slow.I\'m not sure what all info I should provide in order to make it easy for you to help me, but I\'ll take a stab at it and then add more when you big-brains i
I have this query SELECT l.licitatii_id, l.nume, l.data_publicarii, l.data_limita FROMlicitatii_ue l INNER JOIN domenii_licitatii dl
I have two tables: Table GAME: id(int), added_at(bigint) Table META: id_game(int), meta(VARCHAR(64)) Now, each game can have 0 or more Meta tags related to it. I am trying to retrieve 9 games:
if a query in oracle takes the first time it is executed 11 minutes, and the next time, the same query 25 seconds, with the buffer being flushed, what is the possible cause? could it be that the query
In our database tables we keep a number of counting columns to help reduce the number of simple lookup queries. For example, in our users table we have columns for the number of reviews written, photo
I have a query like this: SELECT * FROM mytable WHERE ((num=8198747 AND class=\'A\') OR (num=1646463 AND class=\'B\') OR
I need to perform normalization on data structure. I have one table with lots of redundant data (42 columns)
加载中,请稍侯......