For questions about making database queries run faster.
I am wondering what's the best type for a price field in SQL Server for a shop-like structure? Looking at …
c# sql-server linq-to-sql database-design query-optimizationWe're using Oracle 11g database. As you may or may not know, if you use wildcard query with "%" in front …
sql oracle indexing query-optimizationI have huge table with 2 columns: Id and Title. Id is bigint and I'm free to choose type of Title …
sql sql-server full-text-search query-optimization sql-server-2008-r2My situation: the query searches around 90,000 vehicles the query takes long each time I already have indexes on all the …
mysql performance join query-optimizationI have SQL table with millions of domain name. But now when I search for let's say SELECT * FROM tblDomainResults …
sql query-optimization sql-likeoI have a table with 2 millions of registers, but it will grow much more soon. Basically this table contains points …
mysql query-optimization database-performanceIn Teradata I can use a statement like ... collect statistics on my_table column(col1) This will gather stats on …
sql database query-optimization teradataI have a database with hundreds of awkwardly named tables in it (CG001T, GH066L, etc), and I have …
sql sql-server query-optimization schemabindinghttp://sqlfiddle.com/#!2/6a6b1 The scheme is given above.. all I want to do is get the results as …
mysql query-optimizationI'm having some problems trying to perform a query. I have two tables, one with elements information, and another one …
sql subquery query-optimization