-
corrupted index
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
You might want to rebuild those indexes.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
You might want to rebuild those indexes.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
Run update Statistics.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
Run update Statistics.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
Run update Statistics.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
I run update statistics and dbcc dbreindex but nothing changes.
I solve the problem in this way:
- I export the table data using bcp and then
- I import my data using bcp
Now it seeems to work ; the two select statements get the same number of rows.
------------
Guy at 9/17/99 2:26:41 PM
Run update Statistics.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
I run update statistics and dbcc dbreindex but nothing changes.
I solve the problem in this way:
- I export the table data using bcp and then
- I import my data using bcp
Now it seeems to work ; the two select statements get the same number of rows.
------------
Guy at 9/17/99 2:26:41 PM
Run update Statistics.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
I run update statistics and dbcc dbreindex but nothing changes.
I solve the problem in this way:
- I export the table data using bcp and then
- I import my data using bcp
Now it seeems to work ; the two select statements get the same number of rows.
------------
Guy at 9/17/99 2:26:41 PM
Run update Statistics.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
-
corrupted index (reply)
I run update statistics and dbcc dbreindex but nothing changes.
I solve the problem in this way:
- I export the table data using bcp and then
- I import my data using bcp
Now it seeems to work ; the two select statements get the same number of rows.
------------
Guy at 9/17/99 2:26:41 PM
Run update Statistics.
Guy
------------
patrizia at 9/16/99 5:47:20 AM
Hi,
I have a question on sqlserver 6.5 with sp5a.
I execute a query like the following
select * from eps_analysis_cm (INDEX = index2)
where ....
the query gets 32 rows.
If I use another index
select * from eps_analysis_cm (INDEX = index1)
where ....
the query gets 0 rows.
Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages
Thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|