LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices


Reply
  Search this Thread
Old 03-05-2008, 09:26 AM   #1
sathiyamoorthy
Member
 
Registered: Feb 2008
Posts: 32

Rep: Reputation: 15
indexing


I am having a table with more than 1000 records, i am not having index in that, while executing that query it occupies the processor..

I created an index, and then executed that query., Now it is not getting executed at all... while seeing the top the processor is busy in WA, that it is waiting for device....

i thought it is because of some process, and tested it again, and again and found that the processor is busy with this device whenever this query is executed...

i dropped the index and tried, now the query is executed but it takes...

any idea ????
 
Old 03-05-2008, 09:51 AM   #2
Robert0380
LQ Guru
 
Registered: Apr 2002
Location: Atlanta
Distribution: Gentoo
Posts: 1,280

Rep: Reputation: 47
you might want to ask this question on a website that is dedicated to helping people with database issues and when you ask it there make sure you state the RDBMS you're using.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
CD Indexing ur-unholyness Linux - Software 1 01-11-2008 06:53 AM
indexing error tommytomato General 3 06-27-2007 08:55 AM
looking for indexing software sucram2g Linux - Software 0 11-07-2006 11:15 AM
Folder indexing joey52 Linux - Newbie 2 02-18-2005 03:05 AM
Appache indexing NewtonIX Linux - Software 7 08-21-2004 08:46 PM

LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise

All times are GMT -5. The time now is 11:32 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration