Viewing 15 posts - 38,821 through 38,835 (of 49,571 total)
ichbinraj (5/29/2009)
Hi did you check the execution plan ?
Yes, I did
if i change any thing on cluster index .. means removing cluster index from sid and item _custom1 .. and...
May 29, 2009 at 1:03 pm
Jack Corbett (5/29/2009)
GilaMonster (5/29/2009)
Jack Corbett (5/29/2009)
Hey you folks who are going to write the book on indexing. How about helping this guy out?Why? You're doing a fine job yourself.
Thanks,...
May 29, 2009 at 12:59 pm
ichbinraj (5/29/2009)
As per your suggestion . I have to create non cluster index on SID and ITEM_custom1 ... right ?
Yup. It should help.
About the auto_update state?
May 29, 2009 at 12:31 pm
And the table structure?
The attachment button is right beneath the text box where you type your post. In the section titled "Post Options"
I can tell you right now that not...
May 29, 2009 at 11:57 am
If you're having performance problems with a particular query, please post table definition, all index definitions, the query and the execution plan, saved as a .sqlplan file, zipped and attached...
May 29, 2009 at 10:26 am
Jack Corbett (5/29/2009)
Hey you folks who are going to write the book on indexing. How about helping this guy out?
Why? You're doing a fine job yourself.
May 29, 2009 at 10:23 am
Not sure I understand what you're asking.
When a row is updated, the changes have to be made to all of the indexes on the table, likewise when rows are inserted.
If...
May 29, 2009 at 10:22 am
As stated about four times already, I was using the web interface that comes with Oracle Express.
May 29, 2009 at 9:29 am
Not much.
Using the same query framework that I used in my blog post on this (http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/)
CREATE PROCEDURE SearchHistory_IsNull (@Product int = NULL, @OrderID int = NULL, @TransactionType char(1) = NULL,...
May 29, 2009 at 7:49 am
Need to get a replacement first. Local hardware store only has IDEs in stock. Best they can do is monday for a SATA, maybe tuesday.
Just as long as a second...
May 29, 2009 at 7:38 am
Jack Corbett (5/29/2009)
Hope you find enough work to keep you busy.
Hope so too. Work's been sparse since early April. Another couple months of this and I might have to start...
May 29, 2009 at 7:25 am
tosscrosby (5/28/2009)
GilaMonster (5/28/2009)
I thought I'd seen everything....Anyone (preferably someone who's telepathic or precog) want to tackle these?
Gail, how are you lucky enough to find all these wonderful folks???
Lurking a fair...
May 29, 2009 at 6:02 am
What I called it in my PASS presentation last year was "Multiple execution paths" (for the proc with multiple queries and if statements). Those are my names though. Call it...
May 29, 2009 at 5:47 am
endo64 (5/29/2009)
Even constant values prevents using the index.
Yes it will. As I said, functions of any form prevent index seeks.
same result with "select * from t where a = 500...
May 29, 2009 at 2:58 am
Viewing 15 posts - 38,821 through 38,835 (of 49,571 total)