Thanks for your suggestion, I modified my query to the following: select * from Test1 a , Test2 b where a.user = isnull(@user,a.user)...
Can you please tell me how to use DTA? Iam using sql server 2005 desktop version. thanks
Hi all, While going through the excecution plan i observed that index scan on clustered index involves lot of cost i.e primary key of one of the...
select * from Test1 a , Test2 b where isnull(a.user,'') = isnull('ashwin',a.user) and isnull(a.city,'') = isnull('california',a.city)...
While going through the execution plans for the query, I observed that Index scan for the clustered index scan on primary key of one of the table...
Indexes are not working in this case, so i would modify the queries depending on the user input for example can i use something like this select...
It is not a clustered index for sure, but how to update statistics for the table.
For doing that do I need to create index again and rebuild it, since I have already dropped the index I created previously. Please suggest. thanks
I created the index but didn t rebuild the index and performed any statistics on the table. Can you please tell how to do that and why should we be...
Thanks Satya for your suggestion, Replacing the coalesce() function instead if isnull() definately improved performance. The query took only 1:54...
Hi martin, I created an index on one of the four columns in Test1 table, but the performance got detoriated further. Now it took 5:00 mins, which...
Hi martins, But I think, indexes to work properly you should have distinct values for columns in the database. Index seek suffers due to null...
Hi martin, Structure of TestCase table Column Name Data Type Allow Nulls =========================================== TestCaseID...
thanks martin, let me explain you in detail, the original query is something like select * from Test1 a , Test2 b where isnull(a.user,'') =...
thanks martin, I modified my query to select * from Test1 a , Test2 b where isnull(b.color,'') = isnull(b.color,'') and...
Hi all, now Iam using the following query: select * from Test1 a , Test2 b where isnull(b.color,'') = coalesce(null,b.color,'') and...
But I think COALESCE does make a whole tablescan so it takes more time than ISNULL function. am I right and is this the only performance...
Thanks again, but what are the performance concerns involved in using these functions ISNULL VS COALESCE. Please give details. thanks
you mean to say that and isnull(a.Test,'') = coalesce(@test,isnull(a.Test,'') ) is equivalent to SET @test = ISNULL(@test, '') SELECT...
Separate names with a comma.
