Thats what I thought but was still wanted to make sure that you didn't have to specify anything spefically to have the view use the index on the parent table. I'm glad you dont :-)
Well I guess that pretty much wraps up my design so far on table fields on the design I am working on! It looks pretty good so far..
Thanks to you and the couple of others that responded to me offline.. Much appreciated...
Joe
Carey Matthew Black <[EMAIL PROTECTED]> wrote:
Joe,
To my knowledge adding an index on a view is not possible. The view
itself has no data in it to index. :)
( and your welcome. I am glad to try to help. :)
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail Beta. __20060125_______________________This posting was submitted with HTML in it___
