corrupted index

[patrizia]

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

[Guy]

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

[Guy]

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

[Guy]

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

[Guy]

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

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

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

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

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

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