List:General Discussion« Previous MessageNext Message »
From:Daniel Kasak Date:April 28 2006 1:24am
Subject:Re: HELP --- Slow SP
View as plain text  
Hardi OK wrote:
> Hi,
>  
> When I used the EXPLAIN command, i see that all of my query are using 
> the correct index.  That's why i was quite sure that index won't be 
> the cause of my slow query problem.
>  
> So, i now should alter the table: remove primary key and recreate index?
>  
If your queries are using the index, then setting up a new primary key 
and indexes will not help. Personally, I would do it anyway, but this 
won't help out in your current case.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@stripped
website: http://www.nusconsulting.com.au
Thread
HELP --- Slow SPHardi OK27 Apr
  • Re: HELP --- Slow SPDaniel Kasak28 Apr
  • Re: HELP --- Slow SPMartijn Tonies28 Apr
RE: HELP --- Slow SPQuentin Bennett28 Apr
  • Re: HELP --- Slow SPDaniel Kasak28 Apr
    • Re: HELP --- Slow SPHardi OK28 Apr
      • Re: HELP --- Slow SPDaniel Kasak28 Apr
RE: HELP --- Slow SPQuentin Bennett28 Apr
RE: HELP --- Slow SPQuentin Bennett1 May
  • Re: HELP --- Slow SPHardi OK3 May