How to create index for all columns in a view?
This is a discussion on How to create index for all columns in a view? within the Database Support forums, part of the Web Development category; Hi, I want to create index for all columns in a view. Can anyone tell me how to do this?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
02-07-2008, 01:49 AM
| |||
| |||
 How to create index for all columns in a view? Hi, I want to create index for all columns in a view. Can anyone tell me how to do this?
__________________ The OXYGEN Delivers edgy, intelligent Technology to all...     |
| Sponsored Links |
|
02-07-2008, 01:53 AM
| |||
| |||
| Re: How to create index for all columns in a view? Hi, This is the simple way to do this. create unique clustered index IXSampleView_Id on SampleView(Id) create index IXSampleView_Name on SampleView(Name) SampleView --- View Name Id -- Primary Column Name --- another Column
__________________ S.Balasubramanian Nothing is impossible |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create View Statement | itbarota | Database Support | 5 | 03-25-2008 09:15 PM |
| How to break text inside the asp.net datagrid columns that exceeds the width? | vadivelanshanmugam | HTML, CSS and Javascript Coding Techniques | 1 | 03-05-2008 02:58 AM |
| how to create stored procedure for view to generate xml? | poornima | ASP and ASP.NET Programming | 3 | 02-25-2008 12:21 AM |
| How to rearrange the columns of the table without lose of data? | kingmaker | ASP and ASP.NET Programming | 1 | 02-21-2008 09:13 PM |
| Count the columns alone having data in a record set | $enthil | Database Support | 4 | 12-04-2007 03:25 AM |
All times are GMT -7. The time now is 06:34 AM.
