-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a star schema but SQL Server 2005 always uses the clustered indexes to access a table. What parameters do I have to set to enable this optimization.
According to http://blogs.msdn.com/sqlqueryprocessing/archive/2007/04/09/how-to-check-whether-the-final-query-plan-is-optimized-for-star-join…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a problem with my SQL query that take time to get all records from database. Any body help me. Below is a sample of database:
order(order_id, order_nm)
customer(customer_id, customer_nm)
orderDetail(orderDetail_id, order_id, orderDate, customer_id, Comment)
I want to get latest customer…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm running a query daily to compile stats - but it seems really inefficient. This is the Query:
SELECT a.id, tstamp, label_id, (SELECT author_id FROM b WHERE b.tid = a.id ORDER BY b.tstamp DESC LIMIT 1) AS author_id
FROM a, b
WHERE (status = '2' OR status = '3')
AND category != 6
AND a.id = b…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi Team,
I am trying to learn SQL query optimization using SQL Server 2005. However, I did not find any practical example where I can improve performance by tweaking query alone. Can you please list some example queries - prior and after optimization?
It has to be query tuning – not adding index…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have googled but I can't find answers for these questions.
Your advice is appreciated.
centOS on vps with 512MB RAM, nginx, php5 (fastcgi), mysql5 (myisam, not innodb).
I need to optimize this app created by some ex-employee. This app is working, but it's slow.
Table:
t1(id[bigint(20)],c1[mediumtext]…
>>> More