Check Model => "Existence of Index" warning

[Jason Vogel]

I selected "Check Model", and I'm getting some warnings of "Existence of
index" for a couple of my tables. What is PD complaining about?

Thanks,
Jason

[Jim Egan]

Post by Jason Vogel
I selected "Check Model", and I'm getting some warnings of "Existence of
index" for a couple of my tables. What is PD complaining about?

Could be that you have no indexes on your table. PD may not realize that a PK doubles as
an index for your DBMS.

[Jason Vogel]

That's what I thought. I had added an index and re-ran the "check model",
but the warning was still there. Hence my confusion. So I tried it again
this morning, and it went away after the addition of the index. Operator
error apparently.

Thanks for the prompt reply,
Jason

Post by Jim Egan

Post by Jason Vogel
I selected "Check Model", and I'm getting some warnings of "Existence of
index" for a couple of my tables. What is PD complaining about?

Could be that you have no indexes on your table. PD may not realize that a PK doubles as
an index for your DBMS.
--
Jim Egan [TeamSybase]
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

[Eduardo Vivar]

thank you!, it was the reason in my case.

Post by Jason Vogel
I selected "Check Model", and I'm getting some warnings of "Existence of
index" for a couple of my tables. What is PD complaining about?

Could be that you have no indexes on your table. PD may not realize that a PK doubles as
an index for your DBMS.
--
Jim Egan [TeamSybase]
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

[unknown]

That is a typical warning to get.
It is typically bad form to have a table with no index at all, so PD
warns you. Its not an error, just a warning. You can disregard, or
change the Check Model settings, so it doesn't even check for indexes.
--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike[at]datamodel[dot]org (can you figure what to change?)
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

Post by Jason Vogel
I selected "Check Model", and I'm getting some warnings of "Existence of
index" for a couple of my tables. What is PD complaining about?
Thanks,
Jason